--创建一个视图
create view v_ip_test as select * from ip_test order by id ;
--使用数据字典来查询数据库中所有的
select * from user_views
select * from user_views where view_name='v_ip_test' --此外应该为大写,否则会查询不出来。
select text from user_views where view_name='V_IP_TEST'
--视图可以执行dml操作
select * from user_updatable_columns;
--显示索引:
--从数据字典中查询所有的索引
select * from ind;
select index_name,uniqueness,status from ind where table_name='EMP';
--索引列的信息写入数据字典:
select * from user_ind_columns;
select column_name,column_position from user_ind_columns where index_name = 'PK_EMP'
--显示序列信息:
select * from seq;
select increment_by,cache_size,max_value,last_number from seq where sequence_name ='DEPTNO_SEQ';
--显示同义词信息:
select * from syn;
select table_owner,table_name from syn where synonym_name='PRIVATE_EMP'