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


Please Help Members By Posting Answers For Below Questions

What is nvl?

790


Inline the values in PL/SQL, what does it mean.?

855


What is field delimiter?

793


What are primary key and foreign key and how they work?

745


Can we enter data in a table in design view?

714






What is before trigger?

736


Can we rollback after truncate?

754


what is a view? : Sql dba

814


what is sp_pkeys? : Transact sql

889


how can we optimize or increase the speed of a mysql select query? : Sql dba

689


What is a variable in sql?

725


What mean sql?

740


Does mysql_real_escape_string prevent sql injection?

693


which tcp/ip port does sql server run on? : Sql dba

706


Is the primary key an index?

763