Home » RDBMS Server » Server Utilities » downloading stored procedures
downloading stored procedures [message #69899] Mon, 18 March 2002 19:20 Go to next message
Bharathi
Messages: 6
Registered: March 2002
Junior Member
s there any way of downloading stored procedure from oracle.???

Report message to a moderator

Re: downloading stored procedures [message #69920 is a reply to message #69899] Tue, 19 March 2002 22:57 Go to previous message
Vijay
Messages: 116
Registered: September 1999
Senior Member
select text from all_source (or user_source) where name = procedure_name and type = 'PROCEDURE'. Else, if you have utilities like TOAD or SQL NAVIGATOR, you can easily view the procedure content.

Report message to a moderator

Previous Topic: Import not successful
Next Topic: Re: OCP Exam Papers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 23:38:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.