Technical Blog

Oracle Database 11g Release 2 introduces a new feature called Recursive Subquery Factoring with the help of which you can solve your Sudok...

select dbms_xdb.gethttpport as "HTTP-Port", dbms_xdb.getftpport as "FTP-Port" from dual; begin dbms_xdb.sethttpport(...

create table TAB1 ( col1 VARCHAR2(5),col2 VARCHAR2(5), col3 VARCHAR2(5),  col4 VARCHAR2(5),   col5 VARCHAR2(5)) ; create table TAB2 (  col1...

•During conventional insert operations , Oracle reuses free space in the table During such operations, Oracle also maintains referential...

1) Hint to use with Like clause If your SQL contain a LIKE clause then you could consider using a hint on the column where an index exi...