While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?
Answer Posted / rajeshwaran
First two rows will be inserted and the third entry will
cause Run time error and the execution will be terminated
by inserting first two rows into the table.
| Is This Answer Correct ? | 4 Yes | 10 No |
Post New Answer View All Answers
what are enums used for in mysql? : Sql dba
What is delete command in sql?
what are set operators in sql? : Sql dba
What is restrict in sql?
Differentiate between pl/sql and sql?
What are the benefits of triggers?
what is index? : Sql dba
What does partition by mean in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is schema in sql example?
What is a database? Explain
Can we use distinct and group by together?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
Can we use ddl statements in stored procedure sql server?
What is bulk collect in pl sql?