select distinct name from user_source where type = 'PROCEDURE';
select object_name,object_type from dba_objects where object_type='TABLE' or object_type='PACKAGE'; 要求连接的用户有dba权限
写错了,后面一个应该是'PROCEDURE'
我想我要说清楚一点! 我要列出的是我自己创建的表,不包括系统表!select object_name,object_type from dba_objects where object_type='TABLE'; 这一句把所有的表都列出来了!
select object_name,object_type from user_objects where object_type='TABLE' or object_type='PROCEDURE';
select object_name,object_type from dba_objects where object_type='TABLE' and owner='模式'; --模式=用户名或者用PL/SQL Developer 5吧 http://www.allroundautomations.nl/plsqldev.html
select object_name,object_type from user_objects where object_type='TABLE' or object_type='PROCEDURE';
要求连接的用户有dba权限
我要列出的是我自己创建的表,不包括系统表!select object_name,object_type from dba_objects where object_type='TABLE'; 这一句把所有的表都列出来了!
select object_name,object_type from dba_objects where object_type='TABLE' and owner='模式';
--模式=用户名或者用PL/SQL Developer 5吧
http://www.allroundautomations.nl/plsqldev.html