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 |
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is the difference between a vector and an Array? (Java)
How do you bind variables in oracle?
What happens if recursive calls get out of control?
what is null value?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
12. Display the client name in upper case only and in lower case only.
What is the difference between a primary key & a unique key?
How many types of segments in Oracle?
What is forall Statement ?
What are different Oracle database objects?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.