Can we create more than one constraint to column ?
Answer Posted / 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 |
Post New Answer View All Answers
What is an oracle transaction?
What is bulk load in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
what is the difference between data migration and production migration.
How do I know if oracle is installed on windows?
What is a trigger and what are its types?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is the difference between view and materialized view in Oracle?
Give the advantages and disadvantages of clusters.
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is recycle bin in Oracle?
How many types of cluster table in Oracle?
What is the difference between 10g OEM and 11g OEM?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?