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 much ram can sql express use?

0 Answers  

---

What is varray in pl sql?

0 Answers  

---

How is use pl and sql?

0 Answers  

---

Which version of sql do I have?

0 Answers  

---

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---

How to access the current value and next value from a sequence?

6 Answers  

---

What are the ddl commands?

0 Answers  

---

What does “select count(1) from tab” result?

10 Answers   IBM,

---

Can we join tables without foreign key?

0 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

Explain the insert into statements in sql?

0 Answers  

---

Explain the steps needed to create the scheduled job?

0 Answers  

---