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.

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.

How to name query output columns in oracle?

0 Answers  

---

what is a Nested Loop join?

0 Answers  

---

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

0 Answers   CGI,

---

What is an oracle?

0 Answers  

---

how to find full database size

1 Answers   BirlaSoft, Consultancy,

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---

What is the oracle implicit cursor?

0 Answers  

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

0 Answers  

---

What is SAVE POINT ?

5 Answers  

---

What is connection pool in oracle?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

What is sharded cluster?

0 Answers  

---