Technical Blog

This example shows you that  Usage of  Analytic function will make query good in performance   select mxid,obj#,dataobj#,owner#,name,j.nam...

 1) What is the difference between an INLINE VIEW And SQL WITH CLAUSE ?   The WITH query_name clause lets you assign a name to a subquery...

The fewer side-effects a function has, the better it can be optimized within a query, particular when the PARALLEL_ENABLE or DETERMINISTIC ...

    The Oracle network architecture encompasses many components - all of which neatly corresponds to the OSI networking model (see below Fig...

  Less Overhead on Unindexed Foreign Keys    A table level share lock is placed on unindexed foreign keys in a child table when doing an ...