利用ORACLE的系统表进行操作。
ALL_开头
select * from sys.all_all_tables;
select *from sys.all_tab_cols;
select * from sys.all_tab_columns;
具体例子:
SELECT * FROM SYS.All_Tab_Columns tc
where tc.TABLE_NAME='SD_DUTY_LOG'
AND tc.column_name LIKE 'HNSLT_NET%'
附上DBA常用的一些表。
select username from dba_users;
select * from dba_data_files;
select * from dba_objects;
select * from dba_tables;
select * from dba_sequences;
select * from dba_views;
select * from all_views;
select * from dba_db_links;