Answer Posted / chiyan

Hi all, i go wth RK....plz dnt mislead others...best example
is me for dat case......i jst told the answer what i read
frm one another person !!!!!!!!!!The interviewer jst sacked
me out of the panel...so jst dnt laugh but think guys nd
gals.......

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

1403

---

Explain an exception?

715

---

How to speed up webrick?

814

---

What are the ansi data types supported in oracle?

689

---

Why cursor variables are easier to use than cursors?

758

---

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1929

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4276

---

What is the difference between translate and replace in oracle?

886

---

What is a select query statement in oracle?

704

---

What is oracle rowcount?

806

---

What are the predefined tablespaces in a database?

742

---

Can you drop an index associated with a unique or primary key constraint?

756

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1831

---

Oracle

2108

---

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

785

---