Answer Detail: RE: write a sql query to reflect changes made in one table if u have two tables Emp1& Emp2.

GeekInterview.com > Interview Questions > Oracle > General

Print |

Question: write a sql query to reflect changes made in one table if u have two tables Emp1& Emp2.

November 11, 2008 17:22:34	#2
Mad Hatter	Member Since: November 2008 Total Comments: 5
RE: write a sql query to reflect changes made in one table if u have two tables Emp1& Emp2.
For example, if tables Emp1 and Emp2 both have identical structure, and some changes were applied in them, then MINUS can show the difference. Like select * from Emp1 MINUS select * from Emp2 UNION select * from Emp2 MINUS select * from Emp1