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
How do you select unique values in sql?
What is difference between joins and union?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What is oracle sql developer?
What is linq to sql?
Explain the uses of a database trigger?
What is sql and its types?
what are the security recommendations while using mysql? : Sql dba
How do I use google cloud in sql?
How is data stored on a disk?
How to fetch alternate records from a table?
What is record type in pl sql?
Explain autonomous transaction.
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is sql query limit?