Home » SQL & PL/SQL » SQL & PL/SQL » Understanding Document [PL/SQL] (Oracle 9i-PL/SQL)
Understanding Document [PL/SQL] [message #319375] Sat, 10 May 2008 04:13 Go to next message
Messages: 1
Registered: May 2008
Location: India
Junior Member
Can anybody suggest me how to analyse existing PL/SQL packages & stored procedures and create an understanding document.

We have requirement; there is some code exists in database and we don't have any supporting documents for that database.So we are trying to analyse and understand whats already there...

It would be great if somebody guides me what are all the things needs to be identified and documented and also format of the document...etc

It may be a silly question,but need your guidance.

Thanks in advance,
Re: Understanding Document [PL/SQL] [message #319453 is a reply to message #319375] Sun, 11 May 2008 09:34 Go to previous messageGo to next message
William Robertson
Messages: 1642
Registered: August 2003
Location: London, UK
Senior Member
There is pldoc (open source), or if you use PL/SQL Developer you could look at the PL/SQL Doc plug-in.
Re: Understanding Document [PL/SQL] [message #319479 is a reply to message #319375] Sun, 11 May 2008 18:47 Go to previous message
Messages: 49
Registered: April 2008
Location: Brighton, Michigan
I would take the Oracle Supplied Packages reference manual, decide what I like and don't like about it's format, and use that as a starting point. Unfortunately, there is no short-cut for understanding your code.
Previous Topic: Concatenating the results
Next Topic: buffers cleaning
Goto Forum:

Current Time: Mon Aug 21 18:55:44 CDT 2017

Total time taken to generate the page: 0.11585 seconds