What is a nested table?

0 Answers  

---

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,

---

What are the commands youd issue to show the explain plan for select

2 Answers  

---

What is bulk copy or bcp in oracle?

0 Answers  

---

How to define a cusotmer as a supplier in ORACLE R12

0 Answers   Intelligroup,

---

How to drop a stored procedure in oracle?

0 Answers  

---

What happens to the current transaction if the session is ended?

0 Answers  

---

How much memory your 10g xe server is using?

0 Answers  

---

What are the sql clauses supported in the link property sheet ?

1 Answers   Oracle,

---

What is SYSTEM tablespace and When is it Created?

2 Answers  

---

What is an Oracle view?

1 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---