make oracle supports generated keys and refine dialects

1. use prepareStatement(String sql, int columnIndexes[]) instead of prepareStatement(String sql, int autoGeneratedKeys) to make oracle
driver supports generated keys.
2. replace sequence with sequence-identity for native generator in
oracle and postgresql