Yes we can use. for Example create table emp(empno number(5), ename var

Can a table have two primary keys?

Question Posted / jamalvalli

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

Is This Answer Correct ?

18 Yes

38 No

Please Help Members By Posting Answers For Below Questions

describe mysql connection using mysql binary. : Sql dba

1071

How can one get sql*loader to commit only at the end of the load file? : aql loader

1060

Do we need commit after truncate?

1087

What is assignment operator in pl sql?

1042

What is oracle sql called?

925

What is pl sql variable?

995

how to get help information from the server? : Sql dba

944

When is the explicit cursor used ?

1038

Why is %isopen always false for an implicit cursor?

1111

How to get list of all tables from a database?

1160

Why sql query is slow?

1004

Can we call dml statement in function?

1061

How to order siblings in oracle hierarchy queries?

1048

Is postgresql a nosql database?

1164

How insert into statements in sql?

1079