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 many sql statements are used?

1063

discuss about myisam index statistics collection. : Sql dba

998

Is pl sql better than sql?

1084

What is sql resultset?

1036

What is implicit cursor in pl sql?

1141

Why do we need cursor in pl sql?

1181

how to drop an existing table in mysql? : Sql dba

1084

How does a trigger work?

1140

what is rollback? : Sql dba

1174

Explain the structure of pl/sql in brief.

1135

How do you explain an index number?

1179

How can you load multi line records? : aql loader

1119

What does the argument [or replace] do?

1122

What is composite data type in pl sql?

1164

What is latest version of sql?

1095