I have two tables of values.It returns true it all tables contain the same data and for different value it is false. But I don't know the way how oracle tables sql data compare with each other? please let me know.
Hi Garcia ,
Try the bellows query, may be it will help you
(select * from Table1MINUS select * from Table2) UNION ALL (select * from table2 MINUS select * from table1);
After executing this query the output will returned few rows , we know that data on both tables have identical . So rows which will returned by this executing the query present comparison between the table1 and table2 tables.
Thanks
Patrick Opal
Hello!!
I have got the point of your question. This is very significant to the database admin.
I can give some hints about the solution.   Â
You can compare your data by sql query. The most effective conditional statement is ‘ SELECT’.
By which you can start filtering your data.
You must use the where clause to filter a data which is to be compared. The WHERE clause
Denotes criteria that will be matched the condition before query.
By query you can compare your sql database tables.
Â
Regards
Shifflett Laurel
Â
