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!

missing right parenthesis using DECODE and SUBSTR

529810Oct 5 2006 — edited Oct 5 2006

Hello,

Can anyone explain why I am getting missing right parenthesis when trying to execute this query

 INSERT INTO LOCATION_INFO
(LOCATION,REGION)
SELECT SUBSTR(OLD_SYSTEM_SITE_CODE,1,2),  DECODE(SUBSTR(OLD_SITE_SYSTEM_CODE, 1, 2), 'CA', CHICAGO,'TX', DALLAS, NEW YORK)
FROM SITE_MAPPING_TABLE;

Thanks for looking
Mike

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2006

Added on Oct 5 2006

1 comment

646 views