Answer Posted / gurupatham

Column Level Constraints refers Only One Column .Which does
not have the column name at declaration time .
Ex : Create table emp
( empno number primary Key,
--,
--);

Table Level constraints refers one or more than one column .
Which does have column name at declaration time.
Ex: Create table emp
( empno number ,
--,
--,
Constraints pk_con primary Key(empno));

All constraints can be created as Column and Table level
expect Not Null constraints .
Not Null constraints can only be created as column level
constraints . Does not have constraints name.

How do I recompile a procedure in oracle?

955

---

types of indexes and the rationale behind choosing a particular index for a situation.

2501

---

How to experiment a data lock in oracle?

1052

---

Explain rename?

971

---

What is the usage of save points in oracle database?

959

---

What is ADDM Advisor in Oracle?

1167

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1838

---

Why packages are used in oracle?

1064

---

What is a trigger and what are its types in oracle?

1062

---

How to do paging with oracle?

991

---

what is the difference between restoring and recovering?

1009

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2056

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1649

---

How to add another datafile to a tablespace?

1033

---

What is logical backup in oracle?

1012

---