Answer Posted / anil

ANS:
COLUMN LEVEL CONSTRAINT
If we provide constraint along with column while creating the table then it is column level constraint. For column level constraint a constraint name is not mandatory.

TABLE(ROW) LEVEL CONSTRAINT
If we provide constraint after providing all the columns then it is table level constraint.For table level constraint a constraint name is mandatory.

Advantage of table level constraint:
We can create composite PK and composite FK in table level constraints but we cant create these in column level constraints.

Example:
CREATE TABLE oracle_tab
(
ord_id  NUMBER,
pid NUMBER,
qty NUMBER(2),
ord_dt DATE NOT NULL, /*column level constraint(cant be created as table level constraint)*/
price NUMBER(9,1) DEFAULT 0, /*column level constraint(cant be created as table level constraint)*/
CONSTRAINT ord_pk PRIMARY KEY(ord_id,pid), /*table level(can be created either as table level constraint or column level)*/
CONSTRAINT ord_fk FOREIGN KEY(pid) REFERENCES products(pid),/*table level(can be created either as table level constraint or column level)*/
CONSTRAINT ord_ch CHECK(qty>0) /*table level(can be created either as table level constraint or column level)*/
);

Is sql a scripting language?

935

---

What is rtm stands for?

1034

---

what is top in tsql? : Transact sql

1035

---

Is microsoft sql free?

1051

---

what is the difference between undefined value and null value? : Sql dba

1046

---

How does cross join work?

885

---

What is meant by user defined function?

998

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1145

---

How delete all data from table in sql?

958

---

How do I restart sql?

920

---

Why stored procedure is better than query?

890

---

Which is the correct statement about truncate and delete?

1054

---

what are null values? : Sql dba

907

---

What are the types of join in sql?

1038

---

How many commands are in sql?

1013

---