what is the use of composite key constraint?
Answers were Sorted based on User's Feedback
Answer / deva
its used to create a primary keys based on two or more
columns in the particular table.
By the set, those should be unique.
Is This Answer Correct ? | 14 Yes | 3 No |
Answer / srikanth
A composite key is used to club primary key for more than
once column.
PRIMARY KEY(<<COLUMN1>>,<<COLUMN2>>....<<COLUMNN>>)
But the disadvantage is that it will allow duplicates for
any one of the fields.
Example:
CREATE TABLE Example1
(Id INT NOT NULL,Pername VARCHAR(20) NULL,Phno INT NOT NULL
PRIMARY KEY(Id,Phno)
)
Command(s) completed successfully.
INSERT INTO Example1
VALUES(1,'sri',1111)
(1 row(s) affected)
INSERT INTO Example1
VALUES(1,'sri',6666)
(1 row(s) affected)
SELECT * FROM Example1
Id Pername Phno
1 sri 1111
1 sri 6666
As you can see that it is allowing same Id.
Basically Composite Key will take all the fields defined as
a group.So it is least bothered about any one of the field.
Is This Answer Correct ? | 8 Yes | 0 No |
What are the benefits of ordbms?
What is partitioned table in Oracle?
what are stored procedures?
What is the relationship among database, tablespace and data file?
Explain the use of indexes option in exp command.
How to create a single index for multiple columns?
How to fetch the row which has the max value for a column?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
who is the father of oracle and send chodd rules
How many memory layers are in the shared pool?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
What is oracle host variable?