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
17079 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

Which is faster view or stored procedure?

946

Do we need to rebuild index after truncate?

1035

Explain what is a subquery ?

1189

What is dynamic sql in pl sql?

1036

What is plpgsql language?

1065

What is rollback?

1116

what is the difference between $message and $$message? : Sql dba

998

Which is better cte or subquery?

1029

how to select unique records from a table? : Sql dba

1113

how to get a list of indexes of an existing table? : Sql dba

960

Is mariadb nosql?

1041

How to use transactions efficiently : transact sql

1058

what is the difference between delete and truncate statement in sql? : Sql dba

1247

How many types of index are there?

1042

What is cross join sql?

918