yes, we can ex. create table t1 (empno number(4) not null, ename var

Can we create more than one constraint to column ?

Question Posted / tripti gour

Answer Posted / tripti gour

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

Please Help Members By Posting Answers For Below Questions

How to use regular expression in pattern match conditions in oracle?

983

What are the four Oracle system processes that must always be up and running for the database to be useable?

967

What is the Tune Query

2242

How can we find out the current date and time in oracle?

1048

Differentiate between function and procedure in oracle.

1030

How to rename an index?

1015

How to save query output to a local file?

983

Explain do view contain data?

953

What are the varoius components of physical database structure of oracle database?

958

How to rename a tablespace in oracle?

1046

How to run create database statement again?

1092

What is literal?

961

Difference between oracle's plus (+) notation and ansi join notation?

1051

Please explain joins in oracle?

1020

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1977