Technical Blog

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

 Do you have any idea how this queries are working  ?  select * from user_details d where exists (select 1/0 from dual x where d.first_na...

create table ir_temp_feeload (s_category varchar2(800),s_cov varchar2(800),v_rate varchar2(10) ) ;  alter table ir_temp_feeload  add constr...