Answer Posted / nehal

select e.sal from employee where n-1=(Select count(distinct
sal) from emp where sal>e.sal)


Put n=3 for the 3rd highest salary.

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2973

---

Explain oracle left join with an example?

1018

---

How to convert character types to numeric types?

1141

---

What types of joins are used in writing subqueries?

989

---

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1935

---

candidate key is subset of super key but not vice-verse explain

2070

---

Explain temporal data types in oracle

1098

---

Can select statements be used on views in oracle?

1033

---

What are the differences between number and binary_float in oracle?

1107

---

How to connect to the server with user account: sys?

1027

---

What is MTTR advisor in Oracle?

1099

---

How to best split csv strings in oracle 9i?

1049

---

What are oracle functions?

1037

---

Whether any commands are used for months calculation? If so, what are they?

1099

---

What are the different types of trigger and explain its various uses and functions?

1101

---