first two inserted row will be rollback and nothing will be inserted

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 / rahul khanke

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

Answer Posted / rahul khanke

first two inserted row will be rollback and nothing will be
inserted

i think is according to oracle architectur or commit and
rollback , redo and undo FUNDAS

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is cte?

932

What are the types of optimization?

902

Explain the working of foreign key?

1009

What is trigger in pl sql with examples?

998

what is a materialized view? : Sql dba

1018

What are the types of triggers in sql?

1036

what is data control language? : Sql dba

977

Are views faster than queries?

944

What is the use of sqlerrd 3?

908

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

1399

What is difference between table and view?

994

Is sqlite thread safe?

1005

What's the difference between a primary key and a clustered index?

956

What is the current version of sql?

994

What happens when a trigger is associated to a view?

856