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
- 15677 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
How do I save the results of sql query in a file?
Is it possible to update views?
What is an inconsistent dependency?
How to add a column ‘salary’ to a table employee_details?
What is sql injection owasp?
How to Execute a Package in PL/SQL.?
What are the features of pl sql?
how to shutdown mysql server? : Sql dba
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How do you optimize a stored procedure in sql?
What is t-sql? : Transact sql
How do you go back in sql?
write an sql query to find names of employee start with 'a'? : Sql dba
How many columns should be in an index?
what is sql? : Sql dba
