oracle常用命令

1. select * from user_tables;


2. select * from user_triggers;


3. select * from user_views;


4. select * from user_sequences;


5. select * from user_objects where object_type='FUNCTION';
   select * from user_source where name='MD5'; --(查询函数源代码);


6. select * from user_objects where object_type='PROCEDURE';
   select * from user_source where name='PROCEDURE'; --(查询过程源代码);


7. select * from user_objects where object_type='PACKAGE';