Unique:
SQL> insert into emp values(eno number(4) unique,ejob varchar(15));
Here unique restricts the user to enter the same value more than once.
Error:Voilating constraint
Distinct:
Type: Posts; User: tykarthick; Keyword(s):
Unique:
SQL> insert into emp values(eno number(4) unique,ejob varchar(15));
Here unique restricts the user to enter the same value more than once.
Error:Voilating constraint
Distinct:
View:
To view only particular column in a table.
Index:
Index is used for searching purpose.