
获取用户表列表:
select * from user_tables;
select * from all_tables;
select * from dba_tables;
获取表的字段:
select * from user_tab_columns where Table_Name='用户表';
select * from all_tab_columns where Table_Name='用户表';
select * from dba_tab_columns where Table_Name='用户表';