| Creating Oracle Triggers [message #371373] |
Tue, 10 October 2000 07:58 |
Will McFadyen
Messages: 1
Registered: October 2000
|
Junior Member |
|
|
I hope that this is the right place to ask this. To most folks this will be very simple but since I am new to Oracle, it makes things pretty difficult to me. I need to create a trigger that will execute the following code that is currently written in MS Access SQL. I wish to change the Access syntax to Oracle syntax to make it work while adding trigger statements to make it fire when the "MATUSETRANS" Table is appended to. Here is the SQL:
UPDATE TEAPROD_INVENTORY INNER JOIN TEAPROD_MATUSETRANS ON (TEAPROD_INVENTORY.LOCATION = TEAPROD_MATUSETRANS.STORELOC) AND (TEAPROD_INVENTORY.ITEMNUM = TEAPROD_MATUSETRANS.ITEMNUM) SET TEAPROD_MATUSETRANS.IT3 = TEAPROD_INVENTORY!IL1
WHERE (((TEAPROD_MATUSETRANS.IT3) Is Null));
TEAPROD is the Database.
Any ideas on rescripting this to make it work on our database? I am using Oracle 8.0. Thanks in advance!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
