Its possible to add more than one primary key for the table
Answers were Sorted based on User's Feedback
Answer / rajesh venati
No, it is not possible, only one primary key is possible for
a table.
It is possible to create a primary key on more than one
column in a table, up to 32 columns. It is called composite
primary key.
Is This Answer Correct ? | 19 Yes | 2 No |
Answer / ravi singh
No, physically its not possible to add more then one primary key on a table, although logically you can create an unique key on a column and put it as not null .
Is This Answer Correct ? | 8 Yes | 1 No |
NO its not possible to add more than one primary key in one table , but using trigger we can make another non_primary column acts as primary key column.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ramesh
No not possibble add more than one primay key on the table
Is This Answer Correct ? | 0 Yes | 0 No |
How many rows will return from dual table?
What is synchronized subquery?
List out the acid properties and explain?
What are triggers and its types?
What is multiple columns?
why sql is used as interpreter frequently rather than a compile?
Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)
How to fix oracle error ora-00942: table or view does not exist
Do view contain data?
diff b/w sub query and co-relater query?
What is the size of partition table?
Explain the working of foreign key?