Answer Posted / selvaraj anna university coe

In Oracle 9i:
-------------

SQL> SELECT MAX(salary) FROM emp WHERE LEVEL=&no CONNECT BY
PRIOR Salary>salary;


Enter value for no: 3

old 1: SELECT MAX(SALARY) FROM EMP WHERE LEVEL=&no
CONNECT BY PRIOR SALARY>SALARY
new 1: SELECT MAX(SALARY) FROM EMP WHERE LEVEL=3 CONNECT
BY PRIOR SALARY>SALARY

MAX(SALARY)
-----------
500000

SQL>

What are data pump export and import modes?

1112

---

In which language oracle has been developed?

1136

---

Can we save images in a database and if yes, how?

1113

---

How to join two tables in a single query using oracle?

1054

---

How to assign query results to variables?

1098

---

What is meant by recursive hints in oracle?

1134

---

How to do a full database export?

1153

---

How to convert character types to numeric types?

1193

---

Explain the difference between a procedure and a function?

1241

---

What is materialized view in Oracle?

1116

---

What are the general rules on data consistency?

1062

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2442

---

How can you use check constraints for self referential integrity?

1018

---

Define oracle database

1099

---

What is the maximum limit on the number of columns in a table?

1152

---