Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create more than one constraint to column ?
- 6 Answers
- 11150 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 |
Are truncate and delete commands same? If so why?
What is bulk copy or bcp in oracle?
How to end the current transaction in oracle?
How to shutdown your 10g xe server from command line?
How to write text literals in oracle?
can we pass two out parameters at a time in function?please answer to my question
what is host string in sql plus? how does it related to database?
Explain the use of grant option in exp command.
What is bulk collect in oracle?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
What is autonomous transaction?
What is ordinary table in oracle?
Oracle General 
