Answer Posted / dayaram & sarfaraz (dost)

select a.empno,a.ename,a.sal from emp a
where &n = (select count(distinct(b.sal)) from emp b where
b.sal>= a.sal

What are the execution control statements?

617

---

What is a table index?

562

---

How to select an oracle system id (sid)?

585

---

Explain the use of grant option in imp command.

576

---

What are nested tables?

671

---

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1524

---

How to turn on or off recycle bin for the instance?

609

---

What is a proxy object?

581

---

How do I spool to a csv formatted file using sqlplus?

545

---

What to do if the startbd.bat failed to start the xe instance?

609

---

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

1844

---

What is a cursor variable?

575

---

How many categories of data types in oracle?

605

---

Explain an exception and its types?

610

---

Explain the difference between a procedure and a function?

555

---