ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 10th, 2007

 

with triiger we can do this......but in sql there is no such thingbut we can do it by viewfor example emp1 is a table and emp2 is view .if you iinsert rows into view tht may maynot reflect in the base table

Mad Hatter

 Profile Answers by Mad Hatter 

• Nov 6th, 2008

 

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