Re: create trigger statement
By a 'shadowtable' do you mean a table whose data exactly duplicates the data of the 'device' table? In which case, why are all these inserts, deletes and updates to 'shadow' necessary on every little change to the 'device' table? Or do you mean something else? Is 'device' the table being shadowed? Does "foreach device from table device" mean "for every value of the column named device in the table named device"? Perhaps when you have more time, you will make all this clear enough so someone here can help you.
PB
Subject
Views
Written By
Posted
4431
June 03, 2006 08:37AM
2103
June 09, 2006 05:29PM
2139
June 09, 2006 09:27PM
2060
June 11, 2006 12:27PM
Re: create trigger statement
2283
June 11, 2006 10:06PM
2020
June 13, 2006 12:04AM
2136
June 13, 2006 12:05AM
2117
June 13, 2006 06:53AM
2033
June 13, 2006 08:24AM
2143
June 13, 2006 09:16AM
2258
June 13, 2006 03:42PM
2167
June 13, 2006 07:45PM
2544
June 14, 2006 12:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.