17,089
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
chanet 2003-12-05
- 打赏
- 举报
推荐: 常用的查看数据库的对象的语句(如:表空间,库对象...)
http://expert.csdn.net/Expert/topic/2507/2507801.xml?temp=.3903467
http://expert.csdn.net/Expert/topic/2507/2507801.xml?temp=.3903467
chanet 2003-12-04
- 打赏
- 举报
查看存储过程:
select distinct name,owner from all_source where owner='用户名';
select distinct name,owner from all_source where owner='用户名';
leecooper0918 2003-12-04
- 打赏
- 举报
看存储过程的文本:
select text from all_source where OWNER='USERNAME'
and TYPE='PROCEDURE' and NAME='PROCNAME'
binbin007 2003-12-04
- 打赏
- 举报
select * from dba_source
ruyuezhang 2003-12-04
- 打赏
- 举报
select * from sys.source$;
其中obj#为dba_objects中对应的object_id.
其中obj#为dba_objects中对应的object_id.
