kannamapettai kisnan

Saturday, December 19, 2009

APEX - $500 it wont happen !

I keep teasing my J2EE developer friends of "HTTP STATUS 500" errors.

Didnt expect to hit the error with the new listener so soon :(


APEX 4.0 Early Adopter



http://forums.oracle.com/forums/ann.jspa?annID=1203






"The new theme used throughout the Application Builder is still a work in progress, especially in respect to Internet Explorer. Therefore we have disabled access from IE at this stage."


This is hilarious, Can APEX team make this permanent :)

Friday, December 4, 2009

Generate days in month

I recently saw a post from Duncan Mein using pipelined function to generate days in month. Neat.

http://djmein.blogspot.com/2009/08/generate-days-in-month-pipelined.html

A comment had an example using dual based query with a 'with' clause and rownum.

This could also be done using the following simple query

select my_date "Date" ,to_char(my_date ,'Day') "Day"
  from (select to_date(level || to_char(sysdate,'/mm/yyyy'),'dd/mm/yyyy')  my_date
          from dual
       connect by level <= to_number(to_char(last_day(sysdate),'dd'))
       )