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
- 17301 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
What is sql trigger example?
Does truncate need commit?
What makes a good primary key?
How do you break a loop in pl sql?
What are database links used for?
What are aggregate functions in sql?
What is identity column in sql server?
What is the usage of the distinct keyword?
How do I create a sql script?
What packages(if any) has oracle provided for use by developers?
What is the difference between mdf and ndf files?
When is a declare statement required?
Which query operators in sql is used for pattern matching?
What is user defined functions?
What are predefined functions in sql?
