Seen on OTN Forums recently (part of a question entitled "HTML not working in PL/SQL block", so I suppose we were warned):
l_col VARCHAR2(30) := to_number(to_char(to_date('01-feb-2011','dd-mon-yyyy'),'dd'));
So the string '01-feb-2011' becomes first a date, then a string again, then a number, before being assigned to a string variable. Much more interesting than boring old
l_col VARCHAR2(30) := extract (day from date '2011-02-01');
Or even,
l_col VARCHAR2(30) := '1';
2 comments:
Boooooorrrring.
They didn't make it a blob.
It would have been even more amusing if it'd included CONSTANT!
Post a Comment