Technical Blog

 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 ...

RAID 2 Data is distributed in extremely small increments across all disks and adds one or more disks that contain a Hamming code for redun...