Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create more than one constraint to column ?
- 6 Answers
- 11052 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 |
What is an Oracle Instance?
What do you know about normalization? Explain in detail?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
What are the tools for Oracle ?
How to create a new oracle data file?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Hi Can any one tell me what are the API's used in requisition import.
How to create a new user account in oracle?
How to use like conditions in oracle?
How do I find the database name in oracle?
What is the data type of dual table?
What does COMMIT do ?
Oracle General 
