Answer Posted / sumeet

select min(sal) from emp where sal in (select top 2 sal from
emp order by sal desc);

Explain alias?

708

---

What are the original export and import utilities?

569

---

Can you tell me how to add new column in existing views?how?How is possible?

930

---

Differentiate between pre-select and pre-query?

616

---

What is different types of joins?

570

---

---

What are the different types of database objects?

524

---

What is query image?

584

---

Explain view?

577

---

What is truncate oracle?

529

---

How to rename an index in oracle?

614

---

how may join possible between (requisition with purchase order)

1697

---

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.

2886

---

what are steps for interface? where is exchange rate defined in which table?

1493

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1468

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1605

---