Answer / Piyush Mishra

There are several types of SQL statements including DDL (Data Definition Language) statements like CREATE, ALTER, and DROP; DCL (Data Control Language) statements like GRANT, REVOKE, and COMMIT; and DML (Data Manipulation Language) statements like SELECT, INSERT, UPDATE, and DELETE.

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

Give the structure of the function ?

2 Answers  

---

What is the use of procedures?

1 Answers  

---

Why schema is used in sql?

1 Answers  

---

..........refers to the disk mirroring

2 Answers   iFlex,

---

what are all the common sql function? : Sql dba

0 Answers  

---

Which is better trigger or stored procedure?

1 Answers  

---

Is it possible to create the following trigger: before or after update trigger for each row?

1 Answers  

---

How do I partition in sql?

1 Answers  

---

What is sql mysql pl sql oracle?

1 Answers  

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1 Answers  

---

Can we use ddl commands in pl sql?

1 Answers  

---