Answer Posted / v.karthikeyan

select * from emp
where &n-1=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)

What happens if variable names collide with table/column names?

1262

---

Why we use bulk collect in oracle?

1111

---

What is a database table in oracle?

1067

---

Can we write insert statement in function in oracle?

1153

---

does the query needs a hint to access a materialized view?

1905

---

Explain overloading. Can functions be overloaded?

1045

---

What is the simplest tool to run commands on oracle servers?

1052

---

Why does Oracle not permit the use of PCTUSED with indexes?

2478

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2383

---

What are the built-in functions used for sending Parameters to forms ?

3432

---

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

1034

---

What is SQL access advisor in Oracle?

1228

---

What is the difference between pre-select and pre-query?

1295

---

How to work with data objects interactively?

1041

---

How to set a transaction to be read only in oracle?

1137

---