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

What are the built-in functions used for sending Parameters to forms ?

3388

---

Compare and contrast between sql and sql server and explain its various functions?

965

---

What is the difference between substr & instr functions?

1228

---

How to run create database statement?

1034

---

Respected sir, Please send me technical questions related to oracle apps..

1813

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1034

---

Why is oracle used?

939

---

Is a rollback possible to any savepoint?

1096

---

What is the data type of dual table?

995

---

How to write text literals in oracle?

1068

---

Difference between oracle's plus (+) notation and ansi join notation?

1105

---

What is coalesce function?

1074

---

What are the differences between char and nchar in oracle?

1096

---

Can you have more than one content canvas view attached with a window ?

2333

---

How to empty your oracle recycle bin?

1022

---