Answer Posted / saleem

select distinct(a.sal) from emp a where &3 = ( select count
(distinct(b.sal) from emp b where a.sal <= b.sal));

What is a tns file?

937

---

Will you be able to store pictures in the database?explain.

928

---

What is an Oracle Instance?

1070

---

Can the query output be sorted by multiple columns in oracle?

933

---

How to establish administrator authentication to the server?

981

---

How to connect to a local oracle 10g xe server?

935

---

How to add a new column to an existing table in oracle?

1068

---

How will you write a query to get a 5th rank student from a table student_report?

1812

---

Give the constructs of a package, function or a procedure.

981

---

What is oracle latest version?

1038

---

What is the quickest way to fetch the data from a table?

999

---

What is difference between cartesian join and cross join?

1016

---

Explain the types of exception?

1081

---

What are the uses of Database Trigger ?

1623

---

How to retrieve data from an cursor to a record?

1012

---