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))

How to order siblings in oracle hierarchy queries?

0 Answers  

---

Does sql between include endpoints?

0 Answers  

---

Is sqlexception checked or unchecked?

0 Answers  

---

What is keys and its types?

0 Answers  

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

0 Answers  

---

will function return more than one value how

9 Answers   Accenture,

---

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

4 Answers   HCL,

---

What is procedure in pl sql?

0 Answers  

---

What is the location of pre_defined_functions.

0 Answers  

---

What if we write return in procedure?

0 Answers  

---

How to avoid using cursors?

0 Answers  

---

what is “go” in t-sql? : Transact sql

0 Answers  

---