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

How to convert characters to times in oracle?

598

---

What are advantages of dateset in datastage?

1751

---

What is system global area (sga) in oracle?

576

---

What do you understand by a database object?

588

---

What is flashback in Oracle?

583

---

---

What are the execution control statements?

621

---

What is Data Dictionary Cache in Oracle?

664

---

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

1184

---

What is a proxy object?

581

---

What is the usage of analyze command in oracle?

615

---

What are nested tables?

675

---

How oracle handles dead locks?

604

---

What is the difference between substr & instr functions?

597

---

What to do if the startbd.bat failed to start the xe instance?

613

---

How to initialize variables with default values?

638

---