Answer Posted / pradeep

To get nth rank salary or max salary two ways

below 5th

select ct , empno, sal from (SELECT max(rownum) ct , empno,
sal FROM emp group by empno, sal ORDER BY sal desc) where
ct =5;

below 2nd

select * from (
SELECT DEPTNO,ENAME,SAL,COMM,
RANK() OVER ( ORDER BY SAL DESC, COMM) poK from emp)
where pok =2;

Explain character-manipulation functions?

1093

---

How do you remove duplicates without using distinct in sql?

942

---

What is sp_helptext?

1033

---

Does pl/sql support create command?

1069

---

What is varray in pl sql?

1035

---

What is index example?

976

---

What is integrity in sql?

1006

---

how to use in conditions? : Sql dba

989

---

How do you update sql?

932

---

What are the advantages of sql? Explain

1072

---

What is pl sql commands?

1010

---

What are the types of records?

971

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2511

---

What do you mean by field in sql?

1056

---

explain commit and rollback in mysql : sql dba

972

---