If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
Answer Posted / eshwari
ur question is not clear.
if ur saying that ur giving unique and not null constraints
to the same column then u can make it as primary key.it
internally supports clustered index also.
if ur saying that ur giving unique and not null constraints
to different columns then u cant make them as primary key
individually.
coz primary key means unique + notnull + clustered index
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is oracle rowcount?
What is a subquery?
How to add a new column to an existing table with a default value?
What happens to the current transaction if a ddl statement is executed?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Which is better Oracle or MS SQL? Why?
How to select an oracle system id (sid)?
Is oracle a relational database?
How to return top 5 rows in oracle?
When system tablespace is created?
What is private procedure oracle?
How to assign query results to variables?
What is the difference between translate and replace?
How to drop a tablespace?