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 / vetrikumaran

IT THROWS THE ERROR.NO ROWS WILL BE INSERTED.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pl/sql language case sensitive?

631


Can I call a procedure inside a function?

549


what is 'mysqlimport'? : Sql dba

570


What is a table?

565


What is sql and explain its components?

595






How can the performance of a trigger be improved?

588


Explain what is a field in a database and record in a database?

604


How do I count duplicates in sql?

545


explain commit and rollback in mysql : sql dba

545


What information is needed to connect sql*plus an oracle server?

585


How do I make sql search faster?

552


Is stored procedure faster than query?

562


What are the various restrictions imposed on view in terms of dml?

518


In pl/sql, what is bulk binding, and when/how would it help performance?

529


What is trigger and stored procedure in sql?

554