Answer / 9896012055

select * salary from table < select max(salary) from table
order by salary;

Answer / a.swarna devi

select max(sal)from table;

Answer / havyas

select sal from table where rownum = 2 order by sal desc

Explain the use of analyse option in exp command.

0 Answers  

---

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 Answers  

---

can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,

---

What is ASM (Automatic Storage Management) in Oracle?

0 Answers   MCN Solutions,

---

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

0 Answers  

---

How to invoke the original export import utilities?

0 Answers  

---

What happens to the indexes if a table is recovered?

0 Answers  

---

diff between DELETE and TRUNCATE?.

14 Answers   HCL, Yalamanchili Software,

---

How to use "in out" parameter properly?

0 Answers  

---

What is meant by raw datatype?

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

How to retrieve data from an cursor to a record?

0 Answers  

---