comparing 2 tables [message #304361] |
Wed, 05 March 2008 00:19  |
ridhi_sundar
Messages: 184 Registered: November 2007 Location: Bangalore
|
Senior Member |
|
|
Hi
I hav 2 tables table a & table b.In these 2 tables i hav the same coloumns.col1, col2, col3. Now i hav to compare these 2 tables and get the data which r in table a but not in the table b. as well as i hav to get the name of the coloumn.
The problem is i hav to get a generalized approach so that i wont use the name of the columns in comparision.
Please suggest a way to solve this.
Regards
[Updated on: Wed, 05 March 2008 00:22] Report message to a moderator
|
|
|
|
|
Re: comparing 2 tables [message #304379 is a reply to message #304364] |
Wed, 05 March 2008 00:41   |
ridhi_sundar
Messages: 184 Registered: November 2007 Location: Bangalore
|
Senior Member |
|
|
i m using the below code
Select * From FA_SYSTEM_CONTROLS minus Select * From FA_SYSTEM_CONTROLS_A
but an error is coming
ORA-01789:querry block has incorect no of result coloumns.
Again how can i get the coloumn name?
Regards
|
|
|
|
|