Answer Posted / smita
Hi,
No , we cant create pk eithout unique index it
implicitelygenerater by oracle.
I want to clear that pk can b on one or more col but only
one pk.
While unique constraint can b one or more col and can b one
or morn unique key in a table
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
what are ddl statements in mysql? : Sql dba
what is 'mysqlcheck'? : Sql dba
Mention what is the plv (pl/vision) package offers?
What is the purpose of the sql select top clause?
What does closing a cursor do?
What is the most restrictive isolation level? : Transact sql
What is plpgsql language?
What is the starting oracle error number? What is meant by forward declaration in functions?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What do you mean by field in sql?
Which is faster union or join?
Which join is default?
what is top in tsql? : Transact sql
Can one improve the performance of sql*loader? : aql loader
What is the difference between function and procedure in pl/sql?