Answer Posted / sandeep

variable_first:=dbms_utility.get_time
variable_last:=dbms_utility.get_time;
dbms_output.put_line('elapsed time':var_first-var_last);

how to fetch alternate records from a table? : Sql dba

825

---

how to see the create table statement of an existing table? : Sql dba

736

---

What is the use of stored procedures?

707

---

Which language is used in sql?

729

---

What is the usage of sql functions?

814

---

---

What is a sql statement?

692

---

What is difference between function and trigger?

719

---

What are basic techniques of indexing?

1071

---

How many joins can you have in sql?

687

---

Does a primary key have to be a number?

689

---

Does normalization improve performance?

763

---

Why do we use function in pl sql?

755

---

Explain the significance of the & and && operators in pl sql.

748

---

Why we use join in sql?

702

---

How can you select unique records from a table?

701

---