字段注釋

select   *   from   user_col_comments;

表注釋

select   *   from   user_tab_comments;

//

查詢字段類型

select column_name,data_type,data_length from user_tab_columns where table_name='TableName' and column_name in ('AGE_ID','MONTH_ID') 

Column_name值為大寫

//

查詢表的主鍵

select * from user_cons_columns where table_name='D_DAY'

//

select column_name from user_cons_columns where constraint_name in (select constraint_name from user_constraints where table_name = 'D_DAY' and constraint_type = 'P')

//查詢某表字段的主鍵名稱及類型

select column_name,data_type,data_length,DATA_PRECISION||','||DATA_SCALE from user_tab_columns v  join  (select column_name from user_cons_columns where constraint_name in (select constraint_name from user_constraints where table_name = 'D_DAY' and constraint_type = 'P')) t using (column_name) where table_name='D_DAY'