Answer Posted / akash

select emp_id,sal from ( select emp_id,sal from emp where
sal < ( select max(sal) from emp) order by sal desc ) where
rownum < 2;

Explain what are the uses of rollback segment?

1067

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1805

---

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

1932

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2384

---

Why should I use oracle database?

1049

---

How to write a query with an inner join in oracle?

1096

---

How to rollback the current transaction in oracle?

1104

---

What is meant by raw datatype?

1118

---

What are the uses of linked server and explain it in detail?

1117

---

How to select all columns of all rows from a table in oracle?

1103

---

How to define an anonymous procedure without variables?

1196

---

What are the uses of Database Trigger ?

1788

---

Does oracle partitioning improve performance?

1053

---

what is the difference between substr and instr function in oracle?

1143

---

Please explain oracle data types with examples?

1132

---