Answer / guest

This value causes the optimizer to choose the rule_based
approach for all SQL statements issued to the instance
regardless of the presence of statistics.

hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..

1 Answers  

---

What is Reduced List of Values?

0 Answers   iFlex,

---

How to define a record variable to store a table row?

0 Answers  

---

Please explan Why static query is more faster than dynamic query ?

2 Answers  

---

How many types of synonyms in Oracle?

0 Answers   MCN Solutions,

---

---

A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?

1 Answers   IBM,

---

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  

---

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  

---

How to define a variable to match a table column data type?

0 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---

How to add another datafile to a tablespace?

0 Answers  

---

What is a database schema in oracle?

0 Answers  

---