There is a syntax highlighting issue in v7.0 when you enter the following script:
CREATE OR REPLACE
PACKAGE aaaaaa
IS
PROCEDURE x;
END;
/
CREATE OR REPLACE
PACKAGE BODY aaaaaa
IS
PROCEDURE x
IS
BEGIN
DELETE FROM abc.co01_part t1
WHERE t1."/BIC/ZKO" = 'Z';
END;
END;
/
Everything after the 'Z' character makes the procedure look as if it was commented out.
It doesn't matter whether the "Z" is in the "WHERE" condition, or as a table column:
Example 1) where = 'Z'
Example 2) 'Z' as <column name alias>
If you change 'Z' to a 'A' or 'B' the syntax highlighting works normally.
If you delete the "Z" from 't1. "/ BIC / ZKO"' and write t1. "/ BIC / KO" = 'Z' , it also works
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center