Checked Exception ?

where to handle Checked exception ? and where-not ?
Java's checked exceptions have become highly controversial and it seems to be accepted in the Java community that checked exceptions should only be used when the exceptions can be handled in the application.
Exceptions that cannot be handled in any meaningful way by application code should be allowed to go on unchecked. for ex : SQLException is a checked exception, application code must handle it, either catching it and doing something with it or explicitly throwing it to calling code.

Do you DUAL ?

DUAL

Work around

select TO_NUMBER ('13,000.09', '99G999D99','nls_numeric_characters = ''.,''') from dual

select TO_NUMBER ('13.000,09', '99G999D99','nls_numeric_characters = '',.''') from dual

get the top n rowns from M rows of a Resultset

select *
from ( select a.*, rownum rnum
        from ( YOUR_QUERY_GOES_HERE -- including the order by ) a
       where rownum <= MAX_ROWS ) where rnum >= MIN_ROWS

The smart way of coding

I had an requirement like
":,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,"

i have to replace the first : with 1 and the second : with 2 and it goes on.....

the solution for that was

select max(sys_connect_by_path(l,',')) from
(select level l
from dual
connect by level <= length(replace(':,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,:,',',')))
start with l=1
connect by l = prior l+1

could have done this way , it would have been better.
i was forced to type manually , LOL [reason : to make sure it is correct.]
it sucks, always.. use ur skills instead of manual service.
for that only we have been hired ;)

Its true, re-read the old things , u will find lot of new in there :)

for rationale
Private virtuals can be overridden in C++