How to open a cursor variable?

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,

---

How to change user password in oracle?

0 Answers  

---

What is connection pool in oracle?

0 Answers  

---

What is flashback Query ? And Use ?

4 Answers   Thermotech,

---

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

0 Answers   ESS,

---

What is concurrency in oracle?

0 Answers  

---

How to view all columns in an existing table?

0 Answers  

---

Please explain oracle left join with an example?

0 Answers  

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

Explain the blob datatype?

0 Answers  

---