OraFAQ Forum: SQL & PL/SQL » Versioning of PL/SQL codes

Home » SQL & PL/SQL » SQL & PL/SQL » Versioning of PL/SQL codes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Versioning of PL/SQL codes [message #256647]

Mon, 06 August 2007 04:17

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.

Report message to a moderator

Re: Versioning of PL/SQL codes [message #256661 is a reply to message #256647]

Mon, 06 August 2007 04:53

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Versioning of PL/SQL codes [message #256666 is a reply to message #256661]

Mon, 06 August 2007 05:05

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

Report message to a moderator

Re: Versioning of PL/SQL codes [message #256672 is a reply to message #256666]

Mon, 06 August 2007 05:22

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends on which system you develop, what tools you use to develop...

Regards
Michel

Report message to a moderator

Re: Versioning of PL/SQL codes [message #256680 is a reply to message #256672]

Mon, 06 August 2007 05:31

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

Report message to a moderator

Re: Versioning of PL/SQL codes [message #256691 is a reply to message #256680]

Mon, 06 August 2007 06:05

Littlefoot
Messages: 21826
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).

/forum/fa/2838/0/

Can't tell about other TOAD versions or PL/SQL Developer.

Attachment: toad_team_coding.PNG
(Size: 4.99KB, Downloaded 1603 times)

Report message to a moderator

Re: Versioning of PL/SQL codes [message #256734 is a reply to message #256647]

Mon, 06 August 2007 08:17

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

Report message to a moderator

Re: Versioning of PL/SQL codes [message #257208 is a reply to message #256734]

Tue, 07 August 2007 14:38

Naif
Messages: 12
Registered: August 2007
Location: KSA

Junior Member

Thanks a lot ....

Report message to a moderator

Re: Versioning of PL/SQL codes [message #257483 is a reply to message #256734]

Wed, 08 August 2007 08:15

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.

Report message to a moderator

Re: Versioning of PL/SQL codes [message #257577 is a reply to message #257483]

Wed, 08 August 2007 12:24

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://technology.amis.nl/blog/?p=846

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 01 08:47:53 CDT 2025