Title: RE: INSERT INTO Syntax: Insert a complete record using a cursor
Hi,
The update method is interesting. I need to think the reprocussions through first, but that may save me a lot of hassle
Good idea!
Thanks,
Hannah
-Original Message-
From
Hannah,
What you are asking is possible only in 9.2. OTOH, you could use SQL to
select from dba_tab_columns to generate INSERT ... script though.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any
Hannah
Maybe you could temporarily change the insert trigger to an update trigger
(create or replace trigger before insert or update on...)
and then simply update the table setting some column to itself. This will
will fire the trigger (and will not change any data in the table).
I didn't unders
.. or i had a similar problem ... i wrote an update trigger to populate the
backup table ... and i did an update the the master table to update a record
back to itself ...
update mytab
set acol = acol;
when the update happens use the :old/:new values to populate the backup
table
-Ori