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
WORKAROUND
None
STATUS
Waiting for fix in a future release of Toad for Oracle
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center