Hi,
is it possible to use a Trigger with an external Table?
thanks.
Printable View
Hi,
is it possible to use a Trigger with an external Table?
thanks.
ok, i just realize that it's not possible. Because Oracle won't do any inserts or other DML Operations on the External table.
But, to perfom my task, is it possible to create a View on the external table and using a INSTEAD OF Trigger to transform and copy the data to an internal Oracle table?
Am i'm missing something?
thanks...
Why do you need a trigger and view to insert external table rows into another table?
Just use simple insert statement.
Tamil
Hi,
where would i use the simple insert statement, to do the insert into a table automatically (as soon as the external table is available)?
thanks...