Technical Blog

To  retrieve only numeric values from both numeric& character value In 10 g Select  regexp_replace(regexp_replace('5RTYDDB',...

DBMS_WM.Compress Workspace  If   you version enabled the tables with  DBMS_WM.EnableVersioning ('TABLE_NAME', 'VIEW_WO_OVERWR...

The Below example shows the difference in execution plan when a composite index is created   SELECT d.ITEM_ID,d.ITEM_DESC,D.UNIT,d.ITEM_...

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