Answer Posted / mamta

select rownum as maxsal,sal
from (select sal from emp order by sal desc)
where rownum <4

Can sub procedure/function be called recursively?

1008

---

What is a table in oracle?

989

---

What are the advantages of oracle?

1031

---

Is insert autocommit in oracle?

1079

---

What is rich query?

989

---

What is snapshot is too old? Give and example for better understand.

1608

---

What is a user role in oracle?

1137

---

How to execute the package in oracle?

1089

---

How to open and close an explicit cursor in oracle?

1062

---

Why do you create or replace procedures rather that drop and recreate.

1015

---

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.

3339

---

What are advantages of dateset in datastage?

2268

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4370

---

What is translate in oracle?

1105

---

Can you have more than one content canvas view attached with a window ?

2333

---