Answer / sawant

Due to insufficient Shared SQL pool size.

Monitor the ratio of the reloads takes place while
executing SQL statements. If the ratio is
greater than 1 then increase the SHARED_POOL_SIZE.

Please explain compound trigger in oracle?

0 Answers  

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

0 Answers   Oracle,

---

Whats the benefit of dbms_stats over analyze?

0 Answers  

---

What are group functions in oracle?

0 Answers  

---

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 Answers  

---

Write a simple Store procedure and pass parameter to it ?

3 Answers   Keane India Ltd,

---

Can we convert a date to char in oracle and if so, what would be the syntax?

0 Answers  

---

How to rename a column in an existing table?

0 Answers  

---

if you ctreate table identity

0 Answers  

---

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

2 Answers   IBM,

---

What is a View ?

3 Answers  

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---