String variables like 'insert' 'update'etc are changed to uppercase when they should not under certain conditions explained below:
1) write the following code in the editor
DECLARE
C_SOMETHING CONSTANT VARCHAR2 (10) := 'NULL';
BEGIN
C_SOMETHING := 'insert';
INSERT INTO emp(EMPNO) VALUES (100000);
COMMIT;
END;
2)Go to View | Toad Options | Editor | Behaviour and click on "Syntax Behaviour"
3)Select "Identifier" and set it to UpperCase
4)Select "Reserved Word" and set it to UpperCase
5)Make sure "String" is set to Unchanged
6)Click Apply and ok
7)Come back to the editor
8)Go to the second line " C_SOMETHING CONSTANT VARCHAR2 (10) := 'NULL';"
9) Replace 'NULL';" by '
10)Move the cursor to another line and just write a comment for example
11)Note that the string insert is changed to INSERT and it remains like this even though you come back to the second line and complete the line (as 'test')
The insert string should remain unchanged
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center