Answer / guest

This value causes the optimizer to the cost-based approach
for all SQL statements in the session regardless of the
presence of
statistics and to optimize with a goal of best throughput.

How to convert character types to numeric types?

0 Answers  

---

Write a syntax for update query in oracle?

0 Answers  

---

Indexes in oracle ?

3 Answers   Keane India Ltd, L&T,

---

What is a data lock in oracle?

0 Answers  

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

2 Answers   IBM,

---

How to Truncate Table in Oracle

0 Answers   HCL,

---

difference between procedures and function?

7 Answers   IBM,

---

what is the syntax of update command?

3 Answers   Semantic Space,

---

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---

10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.

3 Answers   Wipro,

---

Can we write dml statement in function in oracle?

0 Answers  

---

What is autonomous transaction?

6 Answers  

---