Answer Posted / hanumantha r challa

select * from emp a where &n=(select count(b.sal) from emp
b where b.sal>=a.sal);

Describe the types of sub query?

939

---

What is oracle in java?

913

---

How to import one table back from a dump file?

972

---

What is oracle open database communication (odbc)?

962

---

Explain what are the different type of segments?

915

---

what is the difference between restoring and recovering?

965

---

How to connect to oracle using service name instead of sid?

964

---

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.

3275

---

Explain the difference between replace() and translate() functions in oracle?

976

---

What are group functions in oracle?

975

---

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

1017

---

What are the differences between primary key and unique key?

949

---

What is the difference between translate and replace in oracle?

1115

---

Explain the use of record length option in exp command.

1027

---

How to define a record variable to store a table row?

1005

---