Technical Blog

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

 1) Please find this   link of some Oracle questions to practice yourself  . 2) Questions

ORA-01555 : snapshot too old : rollback segment number 60 with name  This is because rollback records needed by a reader for consistent rea...