Can we create more than one constraint to column ?
- 6 Answers
- 10073 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vijay
u can create more than one constraint on on column
Vijay Kushwaha
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nageswararao.kamineni
we can create morethan one constrint on column
for example
create table emp11
(empno number(2) primary key,
ename varchar2(20) unique,not null
sal number(7,2));
here a table can containe only one primary key,if we wnat
declare more then one primary key,we can create like this
using unique and not null constarint.
| Is This Answer Correct ? | 2 Yes | 0 No |
yes, we can
ex.
create table t1
(empno number(4) not null,
ename varchar2(30),
constraint u_k_t1 unique key (empno));
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mosab
yes we can create more than constraints to only columns
| Is This Answer Correct ? | 0 Yes | 0 No |
Find all employees in Dept “Marketing”.
What is Trace File ?
What are the ansi data types supported in oracle?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
Where is the export dump file located?
what is the uses of cusor
What is oracle open database communication (odbc)?
How to insert a new row into a table in oracle?
how to see the data (in unix) using dataset in datastage?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
How to create an oracle testing table?
Oracle General 
