Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL (ORACLE 9I)
PL/SQL [message #331060] Wed, 02 July 2008 04:33 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,
I have written a stored procedure and compiled.Now again i have opened the code and changed something and again compiled.Now i want to find the difference of the code.From where will i find it.
Re: PL/SQL [message #331066 is a reply to message #331060] Wed, 02 July 2008 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nowhere in the database but surely in your code development tool.
Oracle database is NOT a code versioning product, it is a database.

Regards
Michel
Re: PL/SQL [message #331075 is a reply to message #331060] Wed, 02 July 2008 04:55 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you haven't kept a copy of the old code outside of the database, then your only means of getting the old version back is to restore a backup taken before you compiled the new code.

Look into the concept of Version Control Software.
Previous Topic: BETWEEN
Next Topic: Blob Column
Goto Forum:
  


Current Time: Sat Dec 03 01:13:39 CST 2016

Total time taken to generate the page: 0.06232 seconds