Answer / krina

we can execute multiple sql statement inside the procedure

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

What are inner and outer joins examples of both?

1 Answers  

---

explain the delete statements in sql

1 Answers  

---

How delete a row in sql?

1 Answers  

---

What program will open a mdb file?

1 Answers  

---

What is a table?

1 Answers  

---

What is duration in sql profiler trace?

1 Answers  

---

What is the difference between drop and truncate commands?

1 Answers  

---

Is mariadb a nosql database?

1 Answers  

---

What is a schema? How is it useful in sql servers?

1 Answers  

---

What is synchronized subquery?

1 Answers  

---

What does subquery mean in sql?

1 Answers  

---

What is sql*plus?

1 Answers  

---