Answer Posted / prashant
Primary key = Unique Index + Not NUll Constraint .
So we can create primary key without Unique index ..But it
is created as combination of both (Unique Index + Not NUll
Constraint ) in oracle databases.
We need not have to create Unique index . :)
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is row_number () in sql?
What is the sql*loader? : aql loader
what are the non-standard sql commands supported by 'mysql'? : Sql dba
how to show all tables with 'mysql'? : Sql dba
What is difference between inner join and self join?
What's the difference between inner join and left join?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What are the parts of a sql statement?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What found sql?
What is the use of nvl function?
Why cross join is used?
What is the usage of distinct keyword?
Is it possible to pass parameters to triggers?
Is there a way to automate sql execution from the command-line, batch job or shell script?