Technical Blog

1) www.orafaq.com/wiki/Main_Page 2) www.orafaq.com/wiki/Scripts 3) www.orafaq.com/wiki/SQL_FAQ

How to Identify OS or Oracle 64 bit or 32 bit select * from v$version; ---------------------------------------------------------------------...

Re: alter table move Processing the code select * from tab where P1 = 110 last a few seconds. After the code alter table tab enable row move...

Alphabets WITH AlphaBet AS ( SELECT CHR((ROWNUM + 64)) AS Character FROM DUAL CONNECT BY level SELECT * FROM AlphaBet; -------------...

Calender of a year select lpad( Month, 20-(20-length(month))/2 ) month , "Su" , "Mo" , "Tu" , "W...