Answer Posted / rajdevar

Guys
i have executed this query in sql plus.This is correct

Select * from EMP_USER A where n-1 = (select count
(distinct (sal)) from EMP_USER B where A.sal<B.sal)

where n=3

reason for using n-1 is below:

1.We are using correlated sub query.so sal value from each
row in outer query(EMP_USER A) is compared with sal of all
the rows in EMP_USER B

eg:
ENAME SAL
----- -----
SMITH 800
KING 5000
FORD 3000

here third highest is 800.so when executing this 800 from
outer query is compared with 800,5000,3000 in inner query
which returns a count(distinct(sal) = 2

if you use n instead of n-1 you get a empty result.

Let me know if this is correct

How to drop an index?

955

---

Can we save images in a database and if yes, how?

1063

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3330

---

Explain cascading triggers.

1073

---

How will you identify oracle database software release?

1008

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1946

---

What is a nested table?

1057

---

How many data types are supported?

1079

---

How can Oracle users be audited?

1109

---

What is set operator oracle?

975

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2142

---

How to call a stored function with parameters?

1039

---

Difference between the “verify” and “feedback” command?

1362

---

How to convert a string to a date in oracle database?

1050

---

How to use subqueries in the from clause in oracle?

1111

---