Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create more than one constraint to column ?
- 6 Answers
- 10903 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 |
How to view the tablespaces in the current database?
how to see the data (in unix) using dataset in datastage?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is the scenario where you take the database to NoArchivelog mode?
Is insert autocommit in oracle?
What is a system tablespace?
What is the relationship among database, tablespace and data file?
Can multiple columns be used in group by in oracle?
Calculate difference between 2 date / times in oracle sql?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Difference between pre-select and pre-query
what is the exact diiference between DBMS and RDBMS
Oracle General 
