Answer Posted / nishi

select sal, (to_char(to_date(sal,'j'), 'jsp')) from emp;

Is insert autocommit in oracle?

1036

---

How to start instance with a minimal initialization parameter file?

1002

---

What is a named program unit?

1036

---

How can you use check constraints for self referential integrity?

931

---

How to use "while" statements in oracle?

1258

---

What is a oracle database?

1012

---

Where is the export dump file located?

1100

---

How to drop an index in oracle?

1035

---

How to use regular expression in pattern match conditions in oracle?

987

---

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.

3289

---

Explain the importance of .pll extension in oracle?

965

---

What is SQL access advisor in Oracle?

1156

---

What are the differences between lov and list item?

1016

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

982

---

Explain the function of optimizer in oracle?

1082

---