how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

1 Answers   IBM,

---

What is a data lock in oracle?

0 Answers  

---

what is difference between cartesian join & cross join even they give same result?

4 Answers   Bank Of America,

---

What is an index associated with a constraint?

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 is a cluster?

2 Answers  

---

Explain the use of show option in imp command.

0 Answers  

---

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

---

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

Explain user account with reference to oracle.

0 Answers  

---

Explain the use of online redo log files in oracle.

0 Answers  

---

How to define an oracle cursor variable?

0 Answers  

---