Technical Blog

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

ORA-00604: error occurred at recursive SQL level 1 ORA-20061: versioned objects have to be version disabled before being dropped ORA-065...

create table testversion ( pkl number primary key,s_var varchar2(10)); ALTER TABLE TESTVERSION CACHE COMPRESS  PARALLEL ( DEGREE Defaul...

    Tablespace Data mining   -----------------------------            Let me call some of my findings as Oracle Tablespace Data minig som...