This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / how to DESC all the existing FUNCTION OR PROCEDURE in oracle 10g? I can use DESC ALL_TABLES for seeing all the existing TABLEs.
-simonqu(后悔);
2006-5-2
(#2943106@0)
-
find a way as follow.
select object_name from all_objects where object_type='FUNCTION' and owner='OWNER'
-simonqu(后悔);
2006-5-3
(#2945429@0)
-
There is a view, "ALL_SOURCE". You can get all of the codes from that view if you have the permission.
-handd(手脚快精神漫的大熊猫);
2006-5-3
(#2945653@0)