Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create more than one constraint to column ?
- 6 Answers
- 11121 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 |
master table and child table performances and comparisons in Oracle ?
how to store only time in a data base table
What is the scope of a local variable?
How to convert a string to a date in oracle database?
Does oracle partitioning improve performance?
What is a database table in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
How to select some columns from a table in oracle?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
How to delete a column in an existing table in oracle?
What is concurrency in oracle?
What is the purpose of save points in oracle database?
Oracle General 
