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 list all indexes in your schema?

1140

---

How to store pictures on to the database?

1030

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1931

---

Why do we use coalesce function in oracle?

1164

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1436

---

How to create a table index?

1226

---

What is a cursor variable?

1213

---

What is a select query statement in oracle?

1025

---

How do we display rows from the table without duplicates?

1014

---

Which is better Oracle or MS SQL? Why?

6479

---

definition of cluster and non-clustered index?

3099

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2758

---

How to drop an index?

1011

---

What are the ways tablespaces can be managed and how do they differ?

2441

---

How to define a data field as not null?

1159

---