#查询当前用户库中的所有表select t.table_name from user_tables t#查询指定表中的所有字段select t.column_name from user_col_comments t where t.table_name = 'EX_YY_ZJJ_01_FRKJCSJ';#查询指定表的主键名称select column_name from user_cons_columns u,user_constraints cwhere u.table_name = 'EX_YY_ZJJ_01_FRKJCSJ' and u.constraint_name = c.index_name and c.constraint_type ='P';