Interested to Buy Any Domain ? << Click Here >> for more details...
While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?
- 8 Answers
- 17077 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / radha sri seshu.kolla
WHEN YOU TRAP THE ERROR TILL THAT ROW THE ROWS WILL BE
INSERTED SUCCESSFULLY
IF YOU DONT HANDLE THE ERROR NO ROWS WILL BE INSERTED.
IF YOU ISSUE COMMIT AFTER EACH ROW THE FIRST TWO ROWS WILL
BE INSERTED SUCCESSSFULLY
IF YOU ISSUE COMMIT AT THE END NO ROWS WILL BE INSERTED
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Which function is used to return remainder in a division operator in sql?
What is the purpose of my sql?
how to add a new column to an existing table in mysql? : Sql dba
Can we use rowid as primary key?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
what is csv? : Sql dba
What is rowid in sql?
What is numeric function sql?
What has stored procedures in sql and how we can use it?
Is pl sql different from sql?
What are the benefits of triggers?
what is denormalization. : Sql dba
What is update query?
What is meant by truncate in sql?
What is trigger types of trigger?
