Answer Posted / allin

5 Different integrity constraints are given

1- Primarykey- creating the index and better performance
2- Unique - should not accept the repeated value
3- NotNull - Should enter any value
4- ForeignKey - can accept values which the values should
existed in primarykey column.Should accept
null values.
5- Check - between the two boundaries.

Thanks & Regards,
RatnaRao
9833847339

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

974

---

What is catalog in Oracle?

1285

---

What's dateware house and what's clustor with practicle example

2140

---

What is bulk copy or bcp in oracle?

1060

---

How to empty your oracle recycle bin?

991

---

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.

3279

---

Hi Can any one tell me what are the API's used in requisition import.

1888

---

What is a proxy class?

980

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2097

---

How can we delete duplicate rows in a table?

940

---

Explain what are the uses of rollback segment?

970

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2104

---

What is Reduced List of Values?

2114

---

What is null value in oracle?

1048

---

Is a rollback possible to any savepoint?

1016

---