Home » SQL & PL/SQL » SQL & PL/SQL » Need help in writing pl/sql query
Need help in writing pl/sql query [message #230153] Wed, 11 April 2007 01:37 Go to next message
Messages: 45
Registered: November 2006
Location: Chennai

I am regularly doing onsite and offshore db script comparison, which i think can be programmed, can you help me in that.
my task is
comparing table columns,datatype, size, nullable, view,indexes, constraints.. etc to see whether it is in sync with the onsite
db script. which we recieve.
my idea is to execute the onsite script on a separate schema and to compare this with offshore schema through a pl/sql program
i thought user_tab_cols has more or less all the columns which i am usually using it. just i need a program to iterate through the
offshore tables,columns,datatype,size,nullable,views,indexes,constraints and compare all this with onsite script which will be loaded
in another schema and the differences needs to be written to a file(may be text file).
If you could help me on this it would be of great help
Thanks in advance
Re: Need help in writing pl/sql query [message #230163 is a reply to message #230153] Wed, 11 April 2007 02:10 Go to previous message
Michel Cadot
Messages: 63945
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why doing things when so much already exist?
Many tools allow you to export metadata: OEM, TOAD, DB Artisan and so on.
If you want to code, you can use DataPump with metadataonly option or dbms_metadata package.

Previous Topic: DATE datatype should accept only date.
Next Topic: Basic scripts for select statement
Goto Forum:

Current Time: Fri Oct 28 05:34:28 CDT 2016

Total time taken to generate the page: 0.22777 seconds