查询某个表空间中的表
select * from user_tables where tablespace_name='TABLESPACE_NAME'
查询某个表中的字段
select column_id, column_name, data_type, data_length, data_precision, data_scale,nullable,data_default from user_tab_columns where table_name = 'Tablename' order by column_id
查询视图信息:
select * from dba_views t where t.view_name='view_name'
select * from user_tables where tablespace_name='TABLESPACE_NAME'
查询某个表中的字段
select column_id, column_name, data_type, data_length, data_precision, data_scale,nullable,data_default from user_tab_columns where table_name = 'Tablename' order by column_id
查询视图信息:
select * from dba_views t where t.view_name='view_name'