Technical Blog

  It is recommend to use NOT EXIST instead of NOT IN ; do you know/thought  why ?  ! . You dont see any differences here because the ...

-----------------------------

EXEC DBMS_WM.ENABLEVERSIONING('GOLF_YARD'); ORA-20229: statement 'delete from mdsys.sdo_geom_metadata_table' failed durin...

  Left outer join retreives all rows in the table1 which is left table ;even if there is no match with table2.   Right outer join retreiv...

  exec dbms_wm.enableversioning('TABLEA'); ORA-20129: table 'TABLEA' does not exist ORA-06512: at "WMSYS.LT"...