i need one insert query in oracle but it will insert multiple row in table.
please help me to do the scenario …
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.
There’s not enough information to help here
i need to know oracle sql query optimization