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

1 Answers   IBM,

---

What is a Temporary Segment ?

2 Answers  

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---

How do you rate yourself in oracle and sql server ?

2 Answers   Keane India Ltd,

---

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

2 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

what is primary key and foreign key when and where have to use

5 Answers  

---

Explain the importance of .pll extension in oracle?

0 Answers  

---

What is rowid and rownum in oracle?

0 Answers  

---

Explain the difference between a procedure and a function? What do you understand by those terms?

0 Answers  

---

Which database is better for os platform dependency?

1 Answers  

---

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

---