SELECT TEXT FROM ALL_SOURCE WHERE OWNER='TEMP' AND NAME='P_name';
SQL> select text from all_source where owner='SCOTT' and name='TESTSE' and type='PROCEDURE';或在DBA Studio的图形界面中也可以看到对象创建的原码。
U r living in stone age , Althougth you can fetch all these information from data dictionary table . Why not just use OEM->Schema Manager or 3rd party tools like PL/SQL devekoper , TOAD(it's free in www.quest.com) etc.
建议用plsql develop,我觉得这个工具挺好用的
select text from user_source where name= Procedurename and type = 'PROCEDURE' order by line;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货