Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create more than one constraint to column ?
- 6 Answers
- 10831 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 |
Explain do view contain data?
What is an oracle user account?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to check the oracle tns settings?
What are the Limitations of a CHECK Constraint ?
Explain about the analyze command in oracle?
How to add a new column to an existing table in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
What is set operator oracle?
How to connect ms access to oracle servers?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
Oracle General 
