Answer Posted / braulio

-- that's it

select * from
(select max(salary) from salary)
where rownum = 2

How to insert a new row into a table in oracle?

1125

---

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?

1353

---

Respected sir, Please send me technical questions related to oracle apps..

1781

---

What is ceil and floor in oracle?

1036

---

What is oracle in java?

929

---

Explain a data segment?

1034

---

What is the relation of a user account and a schema in oracle?

1037

---

How to use values from other tables in update statements using oracle?

1046

---

Is oracle an open source?

1038

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4492

---

What are the advantages of oracle?

988

---

How to define an oracle cursor variable?

992

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2019

---

What to do if the binary spfile is wrong for the default instance?

1024

---

What is a nvl function? How can it be used?

978

---