Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create more than one constraint to column ?
- 6 Answers
- 11304 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 |
Select the Nth lowest value from a table?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
What is the usage of synonyms?
what are steps for interface? where is exchange rate defined in which table?
What are the limitations of check constraint?
how to get the second max val for every group in a table
Explain what are the advantages of views?
How to convert numbers to characters in oracle?
How to drop an index in oracle?
How to filter out duplications in the returning rows using oracle?
What is an external table?
Can you assign multiple query result rows to a variable?
Oracle General 
