How to execute multiple sql statements in a single annonymous
block irrespective of the sql statement result?
Answer Posted / 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 View All Answers
Why is %isopen always false for an implicit cursor?
What are the possible values that can be stored in a boolean data field?
What are the different types of triggers?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What are the different operators available in sql?
what are the difference between clustered and a non-clustered index? : Sql dba
How exception handling is done in advance pl/sql?
How does an execution block start and end in pl sql?
What is data abstraction in sql?
What is integrity in sql?
What is over () in sql?
Can we connect to postgresql using sql developer?
What is data modelling in sql?
what are all the common sql function? : Sql dba
Is pl sql different from sql?