Re: Simple Data warehouse question (cursor)

James wrote:

>>But to answer your question ... look at the options available
>>with TO_CHAR at http://tahiti.oracle.com.
>>--

SELECT TO_CHAR(SYSDATE, 'MM') FROM dual;
SELECT TO_CHAR(SYSDATE, 'MON') FROM dual;
SELECT TO_CHAR(SYSDATE, 'D') FROM dual;
SELECT TO_CHAR(SYSDATE, 'DD') FROM dual;
SELECT TO_CHAR(SYSDATE, 'DAY') FROM dual;

Try harder. ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)