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

Is there any function in oracle similar like group_concat of mysql?

986

---

How to create a new oracle data file?

969

---

How to use subqueries in the from clause in oracle?

1043

---

How to insert a new row into a table in oracle?

1089

---

How to convert characters to times in oracle?

954

---

How will you identify oracle database software release?

942

---

What are the different types of record groups in oracle? Explain each of them

970

---

How data locks are respected in oracle?

1009

---

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

2444

---

Explain what are synonyms used for?

981

---

What are the execution control statements in oracle?

1024

---

Explain the difference between a procedure and a function?

1086

---

What do you understand by database schema and what does it hold?

1177

---

What is the disadvantage of User defind function?

2238

---

Design database draw er diagram for a certain scenario ?

4528

---