Answer / anand

Yes table can have two or more primary key,when we want to
create more then one primary we use unique constranit with
not null or we can create with triggre.

Answer / sandeep yadav

Yes table can have two or more primary key.

Answer / ashwin kumar

yes, a table may have more than 1 primary keys but, of them
we only choose 1 column as identifiable column called
primary key. The other columns are called surrogate keys or
candidate key.

Answer / jamalvalli

Yes we can use. for Example

create table emp(empno number(5), ename varchar2(20),
deptno number(5) add primary key Pk_constraint( empno,
deptno))

What has stored procedures in sql?

0 Answers  

---

Is t sql a programming language?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

What is rank function in sql?

0 Answers  

---

What is the usage of the distinct keyword?

0 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

how to increment dates by 1 in mysql? : Sql dba

0 Answers  

---

How do I find duplicates in two columns?

0 Answers  

---

what are different types of keys in sql?

0 Answers  

---

how to drop an existing index in mysql? : Sql dba

0 Answers  

---

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

---