How to execute multiple sql statements in a single annonymous
block irrespective of the sql statement result?
- 2 Answers
- 4377 Views
- I also Faced
- E-Mail Answers
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
Does mysql support pl sql?
how to see the create table statement of an existing table? : Sql dba
What is a table in a database?
What is left inner join in sql?
What are sql objects?
Are pl sql variables case sensitive?
How can you fetch common records from two tables?
How show all rows in sql?
What is sql server and ase?
Can I call a procedure inside a function?
What is right join sql?
What are the advantages of pl sql?
What can I use instead of union in sql?
explain mysql aggregate functions. : Sql dba
What is secondary key?
