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

What is function and procedure?

983

What does stand for in sql?

915

What is trigger in pl sql with examples?

978

How to get list of all tables from a database?

1106

Why do we use procedures in pl sql?

961

how to increment dates by 1 in mysql? : Sql dba

924

What are the constraints available in sql?

994

what does the t-sql command ident_incr does? : Transact sql

1009

What are the types of dbms?

919

What are different functions in sql?

896

how can we repair a mysql table? : Sql dba

913

What are sql indexes?

934

Which sql statement is used to return only different values?

952

Can we rollback truncate?

943

Can we perform dml on view?

974