Answer Detail: RE: write a sql query to reflect changes made in one t...

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.

February 02, 2007 12:49:35	#1
ddkdhar	Member Since: June 2006 Total Comments: 25
RE: write a sql query to reflect changes made in one t...
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