Answer Posted / 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.

How to apply filtering criteria at group level in oracle?

1042

---

What is oracle open database communication (odbc)?

1028

---

What is a package ? What are the advantages of package ?

1092

---

Can you assign multiple query result rows to a variable?

988

---

How to use "while" statements in oracle?

1327

---

How to assign data of the deleted row to variables?

1075

---

how to make an oracle object

2359

---

What is a read write transaction in oracle?

1093

---

What is ordinary table in oracle?

1159

---

What is the best way to do multi-row insert in oracle?

1067

---

How to get a list of all background sessions in the database?

993

---

How to create an initialization parameter file?

1055

---

What are the attributes of the cursor?

1004

---

What is the dynamic sql in oracle?

1073

---

What is an oracle table?

989

---