This is a cut from one of the scripts that I have written and
it gives me the results you are looking for...
column DAY_NAME new_value file_day noprint
select trunc(SYSDATE) DAY_NAME FROM DUAL;
spool c:\File_&&whichday..txt
HTH
Gregg
|
Results 1 to 9 of 9
Threaded View
|
Click Here to Expand Forum to Full Width |