What happens if the update subquery returns multiple rows?

0 Answers  

---

What is query image?

0 Answers  

---

What is background process in Oracle?

0 Answers   MCN Solutions,

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

How does one get the view definition of fixed views/tables?

0 Answers  

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

3 Answers   HCL,

---

what are the default admin accounts in Oracle 10g ?

0 Answers   MCN Solutions,

---

How to create a temporary table in oracle?

0 Answers  

---

How to list all tables in your schema?

0 Answers  

---

what is null value?

9 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

what are the diffeenes between oracle 9i,oracle 10g

2 Answers  

---