获取表:select table_name from user_tables; //当前用户的表 select table_name from all_tables; //所有用户的表 select table_name from dba_tables; //包括系统表select table_name from dba_tables where owner='用户名' user_tables:table_name,tablespace_name,last_analyzeddba_tables:ower,table_name,tablespace_name,last_analyzedall_tables:ower,table_name,tablespace_name,last_analyzedall_objects:ower,object_name,subobject_name,object_id,created,last_ddl_time,timestamp,status 获取表字段:select * from user_tab_columns where Table_Name='用户表';select * from all_tab_columns where Table_Name='用户表';select * from dba_tab_columns where Table_Name='用户表';user_tab_columns:table_name,column_name,data_type,data_length,data_precision,data_scale,nullable,column_idall_tab_columns :ower,table_name,column_name,data_type,data_length,data_precision,data_scale,nullable,column_iddba_tab_columns:ower,table_name,column_name,data_type,data_length,data_precision,data_scale,nullable,column_id
select * from dba_tab_columns order by owner, table_name, column_id;把两个结果比对一下
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货