四、序列号

　　查看序列号，last_number是当前值

sql>select * from user_sequences;

　　五、视图

　　查看视图的名称

sql>select view_name from user_views;

　　查看创建视图的select语句

sql>set view_name,text_length from user_views; sql>set long 2000; 说明：可以根据视图的text_length值设定set long 的大小 sql>select text from user_views where view_name=upper('%26amp;view_name');

　　六、同义词

　　查看同义词的名称

sql>select * from user_synonyms;

　　七、约束条件

　　查看某表的约束条件

sql>select constraint_name, constraint_type,search_condition, r_constraint_name from user_constraints where table_name = upper('%26amp;table_name'); sql>select c.constraint_name,c.constraint_type,cc.column_name from user_constraints c,user_cons_columns cc where c.owner = upper('%26amp;table_owner') and c.table_name = upper('%26amp;table_name') and c.owner = cc.owner and c.constraint_name = cc.constraint_name order by cc.position;

lJ d nV!L^F*Bd%?[本_文_来_源_于_我_的_学_习_网IT认证ORACLE/CIW认证 http://Www.GZU521.Com ]lJ d nV!L^F*Bd%?

　　八、存储函数和过程

　　查看函数和过程的状态

sql>select object_name,status from user_objects where object_type='function'; sql>select object_name,status from user_objects where object_type='procedure';

　　查看函数和过程的源代码

sql>select text from all_source where owner=user and name=upper('%26amp;plsql_name');

本文共4页: 第 [1] [2] [3] [4] 页