Home » SQL & PL/SQL » SQL & PL/SQL » Comparing two tables (Oracle 10g)
Comparing two tables [message #301057] Tue, 19 February 2008 01:42 Go to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
How to compare two tables to check if they're identical ? Any query on data dictionary table would help ?
Re: Comparing two tables [message #301060 is a reply to message #301057] Tue, 19 February 2008 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_tab_columns is a start point.
Identical in what? To which point? Datatype, precision, scale, length, character set, data...?

Regards
Michel
Re: Comparing two tables [message #301075 is a reply to message #301060] Tue, 19 February 2008 02:35 Go to previous messageGo to next message
hidnana
Messages: 87
Registered: November 2007
Location: chennai
Member
Identical in everything structure and data....
Re: Comparing two tables [message #301082 is a reply to message #301075] Tue, 19 February 2008 02:56 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Structure is in the dictionary.
Data are in your tables.


Regards
Michel
Previous Topic: Calling stored procedure from multiple clients?
Next Topic: Needed SQL Help
Goto Forum:
  


Current Time: Tue Dec 06 00:06:03 CST 2016

Total time taken to generate the page: 0.04986 seconds