Answer Posted / dayaram & sarfaraz (dost)

select a.empno,a.ename,a.sal from emp a
where &n = (select count(distinct(b.sal)) from emp b where
b.sal>= a.sal

How do I manually create a database in oracle?

1019

---

Explain what are the different type of segments?

965

---

What is catalog in Oracle?

1362

---

What are the uses of synonyms?

1135

---

Describe varray?

1056

---

Is it possible to split the print reviewer into more than one region ?

2280

---

What are the restrictions on external table columns?

1052

---

Is oracle a language?

943

---

What are the varoius components of physical database structure of oracle database?

1006

---

Oracle

2375

---

How to use "while" statements in oracle?

1321

---

What do you mean by group by clause?

1042

---

what are the advantages of running a database in archive log mode?

2201

---

What is a named program unit?

1074

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1043

---