Answer Posted / amrish singh

this is the query for retrieving nth highest salary from
table emp
select e.sal
from emp e
where n-1=(select count(*) from emp s where s.sal>e.sal)

putting the value of n we get the required result.

List out the types of joins.

1155

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1915

---

How to convert a date to char in oracle? Give one example.

1068

---

How to connect asp pages to oracle servers?

1072

---

How to create a table in a specific tablespace?

974

---

Can a formula column be obtained through a select statement ?

2321

---

Can multiple columns be used in group by in oracle?

985

---

What is the difference between view and materialized view in Oracle?

1149

---

Explain the different normalization forms?

1088

---

What is a proxy class?

1045

---

Difference between varchar and varchar2 data types?

1183

---

How many types of auditing in Oracle?

1033

---

What are the components of logical database structure in oracle database?

1086

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2136

---

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

1050

---