How to execute multiple sql statements in a single annonymous block irrespecti

How to execute multiple sql statements in a single annonymous
block irrespective of the sql statement result?

Question Posted / g sivanagaraju

2 Answers
4027 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to execute multiple sql statements in a single annonymous block irrespective of the sql statem..

Answer / krina

we can execute multiple sql statement inside the procedure

Is This Answer Correct ?

0 Yes

0 No

How to execute multiple sql statements in a single annonymous block irrespective of the sql statem..

Answer / gourav joshi

hi,
For eg u want to insert 3 data at a same time so u can use
annonyoums block for eg emp_id,Name,Salary u want to insert
data in a table u can use this annoynomous blck

Begin
Insert into table name values(1, 'gourav',2000);
Insert into table name values(2, 'joshi',6000);
Insert into table name values(3, 'ram',4000);
end;

then execute

Is This Answer Correct ?

0 Yes

1 No

Post New Answer