Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private boolean assertDataTypeInternal(String tableName, String columnName, String dataType) throws SQLException {
- DAO.executeQuery(
- "select utc.DATA_TYPE || '( ' || utc.data_length || ' )' from user_tab_cols utc where utc.table_name = upper(?) AND utc.COLUMN_NAME = upper(?) "
- , new Object[]{tableName.toUpperCase(), columnName.toUpperCase()}
- , new ResultSetHandler<Boolean>() {
- @Override
- public Boolean handle(ResultSet rs) throws SQLException {
- List<String> dataTypeNames = new ArrayList<>(10);
- while (rs.next()){
- System.out.println(rs.getString(1));
- return rs.getString(1).equals(dataType);
- }
- return false;
- }
- }
- , schemaName);
- return false;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement