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
Explain unique key in sql.
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What makes a good primary key?
What is basic structure of pl sql?
what is innodb? : Sql dba
what is data manipulation language? : Sql dba
What operators deal with null?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
what are numeric data types? : Sql dba
Why do we use joins?
What is number function in sql?
How do I order columns in sql?
What is rollback?
Why is the cursor important?
List the ways to get the count of records in a table?