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 / 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 are the possible values that can be stored in a boolean data field?
what is the difference between union and union all? : Sql dba
What is cold data?
explain the advantages and disadvantages of stored procedure? : Sql dba
define join and explain different type of joins? : Sql dba
What is difference between primary and secondary key?
What is the sql*loader? : aql loader
What is the difference between unique and primary key constraints?
What is meaning of <> in sql?
What is rank function in sql?
Explain the difference between sql and mysql.
How do I remove sql plus from windows 10?
How many times can we commit in a loop?
What is union?
what is the use of double ampersand (&&) in sql queries?