How can oracle tables SQL data compare with each other?

Asked By Garcia Martines 0 points N/A Posted on - 01/24/2013

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.

• Status: Open
• Question Views: 695
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Shifflett Laurel

Go To Solution

Answered By Patrick Opal 0 points N/A #168669

How can oracle tables SQL data compare with each other?

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

About Patrick Opal

Questions
2

Answers
13

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 01/28/2013
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By Shifflett Laurel 0 points N/A #168670

How can oracle tables SQL data compare with each other?

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

 

About Shifflett Laurel

Questions
2

Answers
154

Best Answers
78

• Vote Up 0 Vote Down

• Posted on - 02/15/2013
• Question Category: Oracle Database