Hi,
I have written this slqplus script
define fileList=&1
TTITLE SKIP 1 LEFT 'Variazione nel flusso Kler''s TIP' SKIP 2
SET NEWPAGE 1
SET SPACE 0
SET LINESIZE 5000
SET PAGESIZE 20
SET FEEDBACK OFF
SET COLSEP '|'
SET UNDERLINE OFF
SET HEADING ON
SPOOL &fileList
COL ISICOD FOR A12 HEADING "Isin"
COL OICR_CODE_T FOR A20 HEADING "Codice OICR T"
COL OICR_CODE_T1 FOR A20 HEADING "Codice OICR T-1"
COL DATA_AGG_T FOR A22 HEADING "Start date T"
COL DATA_AGG_T1 FOR A22 HEADING "Start date T-1"
SELECT rtrim('Cambio di: '
|| (CASE WHEN nvl(A.OICR_CODE ,0) <> nvl(B.OICR_CODE ,0) THEN 'Codice OICR, ' ELSE '' END)
,', ') TIPO_VARIAZIONE,
A.ISICOD,
A.OICR_CODE AS OICR_CODE_T, B.OICR_CODE AS OICR_CODE_T1,
A.START_DATE AS DATA_AGG_T, B.START_DATE AS DATA_AGG_T1
FROM SPR_KLERS_TIP A, (SELECT * FROM SPR_KLERS_TIP B WHERE B.END_DATE = TRUNC(SYSDATE)) B
WHERE A.START_DATE=TRUNC(SYSDATE)
AND A.ISICOD=B.ISICOD(+)
--AND B.END_DATE = TRUNC(SYSDATE)--decode(trim(to_char(sysdate, 'Day')), 'Monday',trunc(sysdate-3), trunc(sysdate-1))
AND (nvl(A.OICR_CODE ,0) != nvl(B.OICR_CODE ,0))
/
spool off
exit
when I execute it I receive this error:
SP2-0158: unknown COLUMN option "--FOR"
Why?
How can I solve?
Thanks a lot, bye bye.