Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error sp2-0158

abdujaparovJan 7 2009 — edited Jan 7 2009
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2009
Added on Jan 7 2009
4 comments
1,179 views