查询所有字段、类型、长度:
select column_name,data_type,data_length from user_tab_columns where table_name=‘T_WEB_SITE’;
查询所有字段注释:
select * from user_col_comments where Table_Name = ‘T_WEB_SITE’
查询表的主键:
select * from user_constraints where table_name = ‘T_WEB_SITE’ and constraint_type =‘P’;(查出主键名称)
select * from user_cons_columns where table_name = ‘T_WEB_SITE’ and constraint_name = ‘TOPERATE’;(TOPERATE是查出的主键名称)