Answer Posted / rajesh

SELECT * FROM (SELECT * FROM EMP ORDER BY EMP_NO) WHERE
ROWNUM < 2

UNION

SELECT * FROM (SELECT * FROM EMP ORDER BY EMP_NO DESC)
WHERE ROWNUM < 2;

How to initialize variables with default values?

1193

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3294

---

What is the string concatenation operator in oracle?

1124

---

Is primary key indexed by default in oracle?

952

---

How do we create privileges in oracle?

1009

---

What are the differences between char and varchar2 in oracle?

1107

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2284

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3175

---

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

2083

---

What is a schema in oracle?

988

---

What is user managed backup in Oracle?

1103

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2232

---

How do I uninstall oracle 11g?

1074

---

What is transport network substrate (tns) in oracle?

1012

---

Explain the use of control file?

1079

---