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

How can we solve sql error: ora-00904: invalid identifier?

0 Answers  

---

What are the advantages of pl sql?

0 Answers  

---

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

---

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 Answers  

---

What are the string functions in sql?

0 Answers  

---

What is the plv (pl/vision) package offers?

0 Answers  

---

what is the stuff function and how does it differ from the replace function? : Sql dba

0 Answers  

---

How many clustered indexes can be created on a table?

0 Answers  

---

What are the operators used in select statements?

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

Explain the order of sql statement execution?

0 Answers  

---

Does normalization improve performance?

0 Answers  

---