Re: Uses of Dual
From: Roy Wagner <roywagner_at_aol.com>
Date: 1996/08/21
Message-ID: <4vg4pt$fc9_at_newsbf02.news.aol.com>#1/1
Date: 1996/08/21
Message-ID: <4vg4pt$fc9_at_newsbf02.news.aol.com>#1/1
- Set Today's Date for Display on Top Title of Report using DUAL
column Today NEW_VALUE xToday noprint format a1 trunc
ttitle -
left 'R.nnn' -
center 'Report Title' -
right xToday skip 2;
- This "trick" sets Today's Date into Global Variable "xToday"
SELECT TO_CHAR(SysDate, 'mm/dd/yy') Today
FROM DUAL;
- Roy Wagner - "Driving my Miata, I always get to where I'm going before I'm ready to stop driving."