Answer Posted / brijesh

hi,

this query gives you the Nth highest salary, the trick is to
write (N-1) in the given place;

select salary from table as table1

where (n-1) =

(select count(salary) from table

where table1.salary<salary);

How to specify default values in insert statement using oracle?

1155

---

Explain drop constraint oracle?

1122

---

What are the various types of snapshots ?

1083

---

What is the disadvantage of User defind function?

2344

---

How to retrieve values from data fields in record variables?

1173

---

How to invoke the data pump import utility?

1230

---

Explain the blob datatype?

1125

---

How to create additional tablespaces for an new database?

1079

---

How many categories of data types in oracle?

1075

---

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

1139

---

How do I know if oracle is installed on windows?

988

---

Explain about integrity constraint?

1181

---

How do I uninstall oracle 11g?

1178

---

What is a partition in oracle?

1207

---

How to create a new user account in oracle?

1065

---