WHEN YOU TRAP THE ERROR TILL THAT ROW THE ROWS WILL BE INSERTED SUCCESSFU

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 / radha sri seshu.kolla

8 Answers
17010 Views
iFlex, I also Faced
E-Mail Answers

Answer Posted / radha sri seshu.kolla

WHEN YOU TRAP THE ERROR TILL THAT ROW THE ROWS WILL BE
INSERTED SUCCESSFULLY
IF YOU DONT HANDLE THE ERROR NO ROWS WILL BE INSERTED.
IF YOU ISSUE COMMIT AFTER EACH ROW THE FIRST TWO ROWS WILL
BE INSERTED SUCCESSSFULLY
IF YOU ISSUE COMMIT AT THE END NO ROWS WILL BE INSERTED

Is This Answer Correct ?

12 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the types of dbms?

967

what is a table in a database ? : Sql dba

1030

What are local and global Indexes and where they are useful.

1435

What is a system versioned table?

975

Explain raise_application_error.

1084

How to create an array in pl/sql?

1059

Why do we need view in sql?

977

Explain what is a subquery ?

1182

What is a sql statement?

946

what is an alias command? : Sql dba

1093

How to write html code in pl sql?

1106

Why do we need cursor in pl sql?

1125

What is anonymous block in sql?

1114

What is $$ in sql?

983

How do I send sql query results to excel?

1056