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

Can we use ddl commands in pl sql?

1164

---

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

1054

---

Can we call a function containing dml statements in a select query?

980

---

what are date and time intervals? : Sql dba

1059

---

what are myisam tables? : Sql dba

1032

---

Why use subqueries instead of joins?

1082

---

What is cascade in sql?

966

---

What information is needed to connect sql*plus an oracle server?

1030

---

What are different functions in sql?

951

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

---

Can you join a table to itself?

1132

---

What is bind reference and how can it be created?

1020

---

What is clustered index sql?

987

---

give the syntax of grant and revoke commands? : Sql dba

1154

---

What is function and procedure?

1037

---