Answer Posted / chaitu

If constraint is defined at the column definition(refer the below exmpls) then it is known to be column level, where as table leevel constraints is defined at the especially incase of composite primary key or composite foriegn key.

Examples
----------

CREATE TABLE CLASS ( ROOM NUMBER(10) CONSTRAINT ID CHECK (ID BETWEEN 1 AND 2000),
..........
.........
........
.........);

Table level
==================

CREATE TABLE CLASS (
ROOM NUMBER(10) ,
SUBJECT VARCHAR2(200),
CODE VARCHAR2(50) NOT NULL, /* Column level constraint*/
ID NUMBER(8,2),
CLASS_DATE DATE,
CONSTRAINT PK_1 PRIMARY KEY (ROOM)); /* table level

How to convert dates to characters in oracle?

1028

---

How many types of cluster table in Oracle?

1027

---

What is a sub query and what are the different types of subqueries?

1115

---

How to create a new table by selecting rows from another table?

1072

---

Explain the different normalization forms?

1066

---

Whether any commands are used for months calculation? If so, what are they?

1089

---

Explain the difference between a procedure and a function?

1158

---

How to get the Installed Oracle Version Information ?

1115

---

Is there an oracle sql query that aggregates multiple rows into one row?

966

---

Which environment variables are absolutely critical in order to run the OUI?

2112

---

What is rich query?

974

---

Explain an index segment?

1100

---

What is a dynamic performance view in oracle?

983

---

Can you tell me how to add new column in existing views?how?How is possible?

1431

---

How to check the oracle tns settings?

1040

---