Home » SQL & PL/SQL » SQL & PL/SQL » Versioning of PL/SQL codes
Versioning of PL/SQL codes [message #256647] Mon, 06 August 2007 04:17 Go to next message
Naif
Messages: 12
Registered: August 2007
Location: KSA
Junior Member
Dear, Hi

Is their any way to manage the change of PL/SQL code of procedure , function , packages and trigger is in database level by generating new version and keep backup of old code in separate location to be used in case of rollback to old code.
Re: Versioning of PL/SQL codes [message #256661 is a reply to message #256647] Mon, 06 August 2007 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes there is a way with database trigger but this is not the database mission to do code versioning this is to the project team to make it.

Regards
Michel
Re: Versioning of PL/SQL codes [message #256666 is a reply to message #256661] Mon, 06 August 2007 05:05 Go to previous messageGo to next message
Naif
Messages: 12
Registered: August 2007
Location: KSA
Junior Member
thanks Mr.Michel

can you please advice me which application/editor can we use it to manage the versioning of PL/SQL code


thanks
Re: Versioning of PL/SQL codes [message #256672 is a reply to message #256666] Mon, 06 August 2007 05:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on which system you develop, what tools you use to develop...

Regards
Michel
Re: Versioning of PL/SQL codes [message #256680 is a reply to message #256672] Mon, 06 August 2007 05:31 Go to previous messageGo to next message
Naif
Messages: 12
Registered: August 2007
Location: KSA
Junior Member
actualy i use TOAD and PL/SQL DEVELOPER but i think it is not support team coding
Re: Versioning of PL/SQL codes [message #256691 is a reply to message #256680] Mon, 06 August 2007 06:05 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
TOAD (my version is 8.6.1), actually, supports Team Coding (if you have bought and installed this option).

./fa/2838/0/

Can't tell about other TOAD versions or PL/SQL Developer.
Re: Versioning of PL/SQL codes [message #256734 is a reply to message #256647] Mon, 06 August 2007 08:17 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Or you can consider a 3rd party tool such as PVCS. I know there is a plug-in for PL/SQL Developer for this product
Re: Versioning of PL/SQL codes [message #257208 is a reply to message #256734] Tue, 07 August 2007 14:38 Go to previous messageGo to next message
Naif
Messages: 12
Registered: August 2007
Location: KSA
Junior Member
Thanks a lot ....
Re: Versioning of PL/SQL codes [message #257483 is a reply to message #256734] Wed, 08 August 2007 08:15 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Microsoft Visual Source Safe also interfaces with TOAD and (I think) SQL Developer, and is a pretty good product.
Re: Versioning of PL/SQL codes [message #257577 is a reply to message #257483] Wed, 08 August 2007 12:24 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://technology.amis.nl/blog/?p=846
Previous Topic: How to clean entire Oracle db/attain empty db
Next Topic: Need Help w/ Select Statement to retrieve rows that contain the same values.
Goto Forum:
  


Current Time: Sat Dec 03 08:00:35 CST 2016

Total time taken to generate the page: 0.10237 seconds