Home » SQL & PL/SQL » SQL & PL/SQL » to get Stored procedures from oracle database
to get Stored procedures from oracle database [message #9042] Wed, 15 October 2003 01:28 Go to next message
ram
Messages: 95
Registered: November 2000
Member
1) sql query to get all stored procedures from oracle database?
2) query to view the source of teh oracle stored procedure.

Thanks in advance

Report message to a moderator

Re: to get Stored procedures from oracle database [message #9043 is a reply to message #9042] Wed, 15 October 2003 05:03 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
1)
user_objects
all_objects
dba_objects

Search for object_types 'FUNCTION','PROCEDURE','PACKAGE' and/or 'PACKAGE BODY'

2)
user_source
all_source
dba_source

The tables are pretty straightforward so I assume you can get the queries written yourself.

MHE

Report message to a moderator

Previous Topic: Week of the month
Next Topic: Division by zero error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 17:26:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.