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();
}