Answer Posted / chandrasekar

Explicit cursor

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1079

---

How to find 3rd highest salary of an employee from the employee table in sql?

1080

---

define sql insert statement ? : Sql dba

1023

---

What is program debugging?

1248

---

Mention what pl/sql package consists of?

998

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

1010

---

What is interval partition?

1053

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2148

---

How can a pl sql block be executed?

944

---

What is sql*plus?

1075

---

What is difference between sql and mysql?

1131

---

Is sql better than access?

1014

---

what is “go” in t-sql? : Transact sql

1104

---

What is rownum?

980

---

Difference between truncate, delete and drop commands?

1082

---