Answer Posted / bharathi sundar

A PRIMARY KEY DOES NOT ACCEDES DUPLICATIONS .
A FOREIGN KEY IS USED FOR LINKING TWO DATABASE TABLES
ABSTRUSELY .

A FOREIGN KEY USES THE PRIMARY KEY IN ANOTHER TABLE,
TO RETRIEVE OR TO IDENTIFY THE CELL VALUES IN ANOTHER
TABLE.........

How do I find my oracle client driver version?

1050

---

What is a partition 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.

3341

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1965

---

How to convert a string to a date in oracle database?

1060

---

What is not equal to in oracle?

1006

---

How to retrieve data from an explicit cursor?

1072

---

how to make an oracle object

2367

---

What is Reduced List of Values?

2183

---

Why use resource manager in Oracle?

1113

---

material view and view disadvantages?

1083

---

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?

2017

---

How do we get field details of a table?

986

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2473

---

How to drop an index?

970

---