How can oracle tables SQL data compare with each other?

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Shifflett Laurel
Answered By 0 points N/A #168669

How can oracle tables SQL data compare with each other?

qa-featured

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

Best Answer
Best Answer
Answered By 0 points N/A #168670

How can oracle tables SQL data compare with each other?

qa-featured

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

 

Login/Register to Answer

Related Questions