Answer Posted / husenaiah.b

select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal

How to import one table back from a dump file?

1025

---

Calculate difference between 2 date / times in oracle sql?

1040

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353

---

Is oracle a programming language?

985

---

Can we insert data in view oracle?

1017

---

How to view existing locks on the database?

1053

---

What is recovery manager in Oracle?

1053

---

Explain the use of parfile option in exp command.

1067

---

How to delete all rows a table in oracle?

1068

---

What is transport network substrate (tns) in oracle?

1043

---

 How to use an oracle sequence generator in a mapping?

1074

---

What is recycle bin in Oracle?

1147

---

How to define default values for formal parameters?

1044

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2175

---

What are the major difference between truncate and delete?

1056

---