Answer Posted / manoj

delete from employee where sal = (select sal from (select sal from employee order by sal desc) where rownum = 3);

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1345

---

Does oracle charge for java?

1053

---

Explain what are the advantages of views?

1064

---

How to change program global area (pga) in oracle?

1084

---

How is it different from a normal table?

1027

---

How do I connect to oracle database?

1111

---

What is a trigger and what are its types in oracle?

1067

---

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?

1040

---

Explain how are indexes update?

1060

---

What is the use of oracle?

1027

---

Briefly explain what is literal? Give an example where it can be used?

1023

---

What are the major difference between truncate and delete?

1052

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3892

---

How to download oracle database 10g xe?

1013

---

What is a data lock in oracle?

1108

---