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 is an oracle function?

1165

---

What is materialized view in Oracle?

1074

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

---

What happens to the current transaction if the session is killed?

988

---

what is dynamic SGA and static SGA

4417

---

Please explain oracle left join with an example?

1046

---

How to start a new transaction in oracle?

1088

---

What is a cognitive schema?

964

---

How to check the oracle tns settings?

1047

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2270

---

What are triggers in oracle?

1039

---

How does oracle handle read consistency?

1097

---

Where are the settings stored for each instance in oracle?

1105

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1382

---

Explain index?

1259

---