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
- 16740 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 the usage of distinct keyword?
Why is stored procedure faster than query?
How do I find duplicates in a single column in sql?
What is difference between stored procedure and trigger?
What does rownum mean in sql?
Can we create index on primary key?
What is the order of sql select?
what is the difference between delete and truncate statement in sql? : Sql dba
what is a stored procedure? : Sql dba
What is the difference between left join and right join?
What is a left join?
How global cursor can be declare with dynamic trigger ?
How do I tune a sql query?
how mysql optimizes distinct? : Sql dba
What is primary key and foreign key with example?
