Related Posts :

• & is not working with oracle insert (0)
  If you have a insert query and the ata has & in between , the database accepts that as escape character and there is no issues with inserts. for eg Insert into TABLE_NAME (...
• Some useful oracle queries (0)
  Some useful queries used in day to day operations Checking locks in database SELECT b.session_id AS sid, NVL(b.oracle_username, '(oracle)') AS username, a.owner AS object_owne...
• What is difference between normal view and materialzed view ? (0)
  Normal Views * A view is simply the representation of a SQL statement that is stored in memory so that it can easily be re-used. * Views have been used to hide the base tables th...
• Understanding materialized view in Oracle (1)
  A materialized view stores both definitions of view plus rows resulting from the execution of the view. It is more efficient to use materialized views if query involves summaries...
• Statistics in Oracle Database and Resolving Performance Issues (0)
  In this post I will explore the common causes of performance issues in database , optimizer statistics , table/index statistics  and table maintenance Common Causes of Performan...
• Oracle 11g new Features – Part 2 (5)
  Further to may last post , Oracle 11g new Features - Part 1 , I am covering some more features here. Client Query Result Cache Oracle 11g allows client’s memory to cache query re...
• Oracle 11g new Features – Part 1 (5)
  Oracle 11g has some pretty cool new features. I am covering some of the Read Only tables and Server result cache features in this post Read only Tables In 10g or prior oracle rel...
• PL SQL Interview questions (0)
  Want to test your knowledge of PL/SQL ? Take the PL- SQL Interview questions test at skill-guru. Some of the questions are specific to oracle but over all they would test the co...