NO ROWS WILL BE INSERTED. IT THROWS 0 ROW(S) AFFECTED

While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?

Question Posted / meenadevi.m

Answer Posted / meenadevi.m

NO ROWS WILL BE INSERTED.

IT THROWS 0 ROW(S) AFFECTED

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How can I make sql query run faster?

754

What is the difference between python and sql?

709

What is difference between sql and oracle?

778

What is partition in sql query?

723

What are inner and outer joins examples of both?

691

What is the purpose of using pl/sql?

830

What is the difference between sql and isql*plus?

704

Are pl sql variables case sensitive?

775

What is sql entity?

742

Can dml statements be used in pl/sql?

777

What are the most important characteristics of pl/sql?

785

What is the difference between instead of trigger and after trigger?

699

What is file based approach?

664

What is pl sql architecture?

686

What is a dynamic query?

762