Answer Posted / karthicksharma

As said earlier UNIQUE is a constraint and can be used
during a table creation to prevent duplication of data .

-----------------------------------------------------
CREATING A TABLE USING UNIQUE CONSTRAINT:
=================================================

eg:
SQL> create table empl1 (name varchar2(15),no number(5)
unique);

Table created.

-----------------------------------------------------

So from this it is clearly implied that UNIQUE constraint
is used to prevent INSERTION AS WELL AS RETRIVAL of non-
duplicate data.

whereas DISTINCT clause can only be used for RETRIVAL of
non-duplicate data.

Whereas DISTINCT is a clause and cannot be used during a
table creation to limit the duplication of data.

-----------------------------------------------------
CREATING A TABLE USING DISTINCT CLAUSE:
===========================================
eg:
create table empl2(name varchar2(15),no number(5) distinct)
*
ERROR at line 1:
ORA-00907: missing right parenthesis

-----------------------------------------------------

What do you understand by pl/sql records?

1011

---

Why should I use postgresql?

1005

---

Explain constraints in sql?

1035

---

How does sql profiler work?

1007

---

what is a record in a database ? : Sql dba

1055

---

What is the difference between rename and alias?

1332

---

What is pl sql record in oracle?

1018

---

What are different types of triggers?

1095

---

Is ms sql is free?

1014

---

When to use inner join and left join?

947

---

What is recursive stored procedure?

1093

---

Does access use sql?

1023

---

When can we use the where clause and the having clause?

1015

---

What is the difference between view and stored procedure?

955

---

What is a primary key example?

948

---