Answer Posted / kotesh

select level,max(salary) from employee
where level=3
connect by prior salary>salary
group by level;

What are some predefined exceptions in pl/sql?

555

---

Is sql a oracle?

528

---

How to get unique records from a table?

528

---

What version is sql?

557

---

Is it important to partition hard disk?

536

---

---

What is the max nvarchar size?

525

---

What is trigger price?

548

---

what are the difference between clustered and a non-clustered index? : Sql dba

531

---

What is denormalization in a database?

595

---

What is the difference between explicit and implicit cursors in oracle?

520

---

What is oracle and pl sql?

665

---

What is pl sql commands?

562

---

What is the use of %rowtype?

541

---

What is a sql select statement?

574

---

What are different categories of sql commands?

639

---