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

What are the different pseudo commands? Explain in general?

1080

---

What is connection pooling in oracle?

973

---

How to view existing locks on the database?

1054

---

How to name query output columns in oracle?

1188

---

How to initialize variables with default values?

1249

---

What is set operator oracle?

984

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2284

---

Design database draw er diagram for a certain scenario ?

4579

---

How to assign a tablespace to a users in oracle?

1048

---

How to concatenate two text values in oracle?

1114

---

How to turn on or off recycle bin for the instance?

1085

---

definition of cluster and non-clustered index?

3035

---

Describe the types of sub query?

1000

---

Respected sir, Please send me technical questions related to oracle apps..

1814

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3053

---