Can we create more than one constraint to column ?
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 |
How to concatenate two text values in oracle?
What happens if the imported table already exists?
What is a read write transaction in oracle?
How to change system global area (sga) in oracle?
difference between procedures and function?
What is ADDM Advisor in Oracle?
What is different bet native dynamic sql and Dbms_Sql?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is user managed backup in Oracle?
What is the implicit cursor in oracle?
What is analyze command used for?
How to install oracle odbc drivers?