How much memory your 10g xe server is using?

0 Answers  

---

What is a shared pool?

1 Answers  

---

Explain the concept of the DUAL table.

2 Answers  

---

How to write a left outer join with the where clause in oracle?

0 Answers  

---

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

1 Answers   IBM,

---

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

0 Answers  

---

How to define default values for formal parameters?

0 Answers  

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

0 Answers  

---

What is a Data Dictionary ?

5 Answers  

---

what are the default admin accounts in Oracle 10g ?

0 Answers   MCN Solutions,

---

how to select second mauximum value in a given table under salary column

6 Answers   Sapient,

---

What do you mean by merge in oracle?

0 Answers  

---