Re: ORA-00923 error - SQL PLUS

Hi,
what is the result of your query ?
And how you manage it to do the spool ?
I see no alias, i see no col xxx new_value.

Try something like this

col sel_alias new_value spool_file noprint

select to_char(sysdate,'dd/mm/yyyy')
"date"||'%'||to_char(sysdate,'dd/mm/yyyy') "fate.txt" as sel_alias from dual;

spool &spool_file

regards
Kay Received on Tue Apr 22 2014 - 13:15:45 CEST