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
itanand
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,
Anand
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: 1643
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
TheSingerman
Messages: 49
Registered: April 2008
Location: Brighton, Michigan
Member
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: buffers cleaning
Next Topic: Trigger on Materialized View
Goto Forum:
  


Current Time: Thu Feb 06 16:26:22 CST 2025