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 jobs use sql?

0 Answers  

---

Mention what are the benefits of pl/sql packages?

0 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

---

Is mariadb a nosql database?

0 Answers  

---

Is it possible to access the current value in a session before accessing next value?

1 Answers  

---

what are null values? : Sql dba

0 Answers  

---

Why we use cross join?

0 Answers  

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

What makes a good primary key?

0 Answers  

---

write a query to display diference between two dates in sql server

2 Answers  

---