Technical Blog

   ORACLE WORKSPACE MANAGER  TOPIC     If there is  a version enabled table 'BILL' and      /*  CREATE TABLE BILL (N_BILLID NUMB...

/*+NO_QUERY_TRANSFORMATION*/ The NO_QUERY_TRANSFORMATION hint causes the optimizer to skip all query transformations including but not li...

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