Can we create more than one constraint to column ?
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 |
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Explain compound trigger in oracle?
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
Describe Referential Integrity ?
How many types of table in Oracle?
What is meant by joins? List out the types of joins.
select statement does not retrieve any records. what exception is raised?
What is the difference between substr and instr?
What are the components of logical database structure in oracle database?
what is the difference between data migration and production migration.
How do we create privileges in oracle?
where we have to use ON clause and where we have to use USING clause in JOINS