Answer Posted / ibrahim

PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
PRIMARY KEY not accepts null values but unique can accept null.

but the core different between primary key and unique is we use primary key to link tow tables with each other but we can not use unique key to do this.

What are the execution control statements in oracle?

1028

---

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

1004

---

What is archive log in Oracle?

1071

---

What is the relation of a user account and a schema?

1064

---

what is the difference between data migration and production migration.

2276

---

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.

3275

---

How to load excel data sheet to oracle database

967

---

How to delete a user account in oracle?

916

---

Describe an oracle table?

989

---

What are the different types of record groups in oracle? Explain each of them

972

---

Does oracle charge for java?

1008

---

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?

2398

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2302

---

Explain database link?

1062

---

What is the use of file param in imp command?

1117

---