Answer Posted / jinnajpr

Normalization is process to avoid the redundancy(duplicate)
which the useful for maintain the database smoothly.

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2004

---

What is not equal to in oracle?

996

---

How can you use check constraints for self referential integrity?

965

---

Explain the use of owner option in exp command.

1041

---

How to get execution statistics reports on query statements?

1085

---

What privilege is needed for a user to create indexes in oracle?

1026

---

Can we call procedure inside function in oracle?

1080

---

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)

2318

---

What is user managed backup in Oracle?

1136

---

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.

3329

---

What is bulk collect in oracle?

994

---

What are the extensions used by oracle reports?

1033

---

How to export your connection information to a file?

1125

---

How can windows applications connect to oracle servers?

1052

---

What is the difference between hot backup and cold backup in oracle?

1008

---