Answer Posted / nishi

yes

What is a cursor variable?

1127

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2322

---

What is the difference between count (*), count (expression), count (distinct expression)?

1004

---

How to rename an existing table?

1126

---

How will you differentiate between varchar & varchar2?

1041

---

How to write a query with a left outer join in oracle?

1062

---

How to rollback the current transaction in oracle?

1054

---

What is ADDM Advisor in Oracle?

1173

---

Explain about achiever in sql?

1034

---

How much memory your 10g xe server is using?

1103

---

How to turn on or off recycle bin for the session?

1109

---

Can we protect our pl/sql source code?

1042

---

What is a table index in oracle?

1131

---

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.

3331

---

How to define a specific record type?

1084

---