Answer Posted / nzabin

select PO_header_id from (select PO_header_id from PO_HEADERS_ALL order by PO_header_id
desc) where rownum <=10 order by PO_header_id;

what is unique key constraint? : Sql dba

1006

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1994

---

What does an inner join do?

1123

---

How can I speed up sql query?

922

---

Explain the difference between triggers and constraints?

946

---

What is the most common sql injection tool?

1010

---

What is a sql schema used for?

1059

---

What is the difference between sql and isql*plus?

1038

---

Can we rollback delete command?

955

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3958

---

Explain the purpose of %type and %rowtype data types?

888

---

What is a nested table in word?

929

---

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

1040

---

How can you fetch first 5 characters of the string?

978

---

How do temporal tables work?

922

---