Answer Posted / pavan

select * from (select ename from emp order by rownuum desc)
where rownum=1;

What is Reduced List of Values?

2125

---

How to use existing values in update statements using oracle?

1032

---

How to start an oracle instance?

979

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2080

---

Explain the use of ignore option in imp command.

994

---

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

4492

---

Explain the dml?

936

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1650

---

How to define an external table with a text file?

1033

---

How do I start tns listener?

1006

---

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2041

---

Where is the export dump file located?

1106

---

What is the parameter mode that can be passed to a procedure?

1005

---

Can multiple cursors being opened at the same time?

1036

---

What is the dynamic sql in oracle?

1029

---