Toad World® Forums

INSERT IN ORACLE


#1

i need one insert query in oracle but it will insert multiple row in table.

please help me to do the scenario …


#2

There’s not enough information to help here. If you are running a single insert statement and multiple rows are being inserted, then there is something else going on in your db - maybe a trigger is firing and doing the extra insert, etc. Either way, it’s doubtful it’s related specifically to Toad, but please provide more info.


#3

There’s not enough information to help here


#4

i need to know oracle sql query optimization