1
2
3
4
5
6
7
8
9
10
11
12
| package com.iplatform.generator.util;
|
| public class SqlUtils {
|
| public static final String ORACLE_QUERY_COLUMNS = new StringBuilder("select t1.*, ucc.constraint_name, uc.constraint_type column_key from (")
| .append("select c.table_name, c.column_name, c.data_type, c.data_length, c.data_precision, c.data_scale, c.nullable, c.column_id, s.comments ")
| .append("from user_tab_columns c, user_col_comments s ")
| .append("where c.table_name like :tablename and c.table_name = s.table_name and c.column_name = s.column_name order by c.column_id")
| .append(") t1 ")
| .append("left join user_cons_columns ucc on ucc.table_name=t1.table_name and ucc.column_name=t1.column_name ")
| .append("left join user_constraints uc on uc.constraint_name=ucc.constraint_name").toString();
| }
|
|
