Geek asks and answers

Local package with database package

I need to somehow compare the local version of pl sql package with the one stored in the database. Is there a “simple” way to do this? I am currently downloading a package from a database, saving it in some kind of file, and doing the diff using some diff tool. This is a bit cumbersome, so I would like to have such a function in ide (it is preferable to use pl sql).

+2
source share
2 answers

Developers typically use version control software to check for differences, maintain version history, and help coordinate code team development. PL / SQL code should not be different. There are many ways to handle code releases, the following is what I saw, not necessarily the “best” way.

Oracle, , CVS SVN. , (/) . ( ) , , , ( ). , , . , .

IDE, , , Toad Team Coding. , , ( / ..). , .

, . , .

+4

sqlplus. all_source, spool . diff "host diff..." "! Diff..." . -b -B diff .

+1

More articles:


All Articles