Link to home
Start Free TrialLog in
Avatar of brgdotnet
brgdotnetFlag for United States of America

asked on

Oracle bulk copy with triggers getting turned off

I am looking at a stored procedure which contains some Oracle sql to buld copy data from a source table to a destination table.
Would such a bulk insert ever result in database triggers being turned off?

sqlString := 'INSERT INTO ' || TRIM(destTable) || SELECT * FROM TRIM(sourceTable);
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial