Answer Posted / kevin sharpless

-- This query wiil return any number of the n items by
using the max/decode statements

select max(decode(rnum,1,salary,null)) max1
,max(decode(rnum,2,salary,null)) max2
from (
select 1 grp_col
,salary
,row_number() over (order by salary asc) rnum
from (
select distinct salary
from emp
)
)
group by grp_col

In oracle there is column command, how will you explain that?

986

---

What is a trigger and what are its types in oracle?

1013

---

How to drop a stored function?

1091

---

Is postgres faster than oracle?

980

---

Explain what does a control file contain?

1043

---

What is a lookup table in oracle?

942

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2073

---

What is materialized view in Oracle?

1046

---

How would you begin to troubleshoot an ORA-3113 error?

2038

---

what is insert all statement in sql

6413

---

How to see free space of each tablespace?

982

---

Why packages are used in oracle?

1011

---

What to do if dba lost the system password?

1104

---

What is the difference between a primary key & a unique key?

1047

---

 How to use an oracle sequence generator in a mapping?

1029

---