Answer Posted / naresh

Here it is the simple solution.

Select Salary from (Select Salary, Rownum from Employee
order by Salary desc) where rownum=2

Should Work
Cheers!
Naresh

Please explain oracle data types with examples?

1075

---

How to use like conditions in oracle?

1063

---

How do we get field details of a table?

982

---

What is concurrency in oracle?

1011

---

What is bulk load in oracle?

1076

---

What privilege is needed for a user to connect to oracle server?

994

---

What is the use of aggregate functions in oracle?

1026

---

How to revoke create session privilege from a user in oracle?

1020

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2035

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2232

---

What happens if you set the sga too low in oracle?

1156

---

What are temporal data types in oracle?

1128

---

How to view the data files in the current database?

1101

---

What are the different types of partitions in oracle?

979

---

defination of bitmap index

2132

---