Convert Java SQL String to Oracle SQL Format in TOAD

At times Toad might reset the capability to strip off / convert the the SQL in Java string format to SQL format. You can have that back, here is how...

1.      View -> Toad Options -> Editor - Code Assist

2.      Under "Make Code"

3.      Click on "Add"

4.      Copy Past below

Name: Java

Quote Character: "

Escape Character: \

{ Java Language Template }

"%SqlText% " +

"%SqlTextNext% " +

like this…

5.      Once you apply these changes:

                                      i.      Copy the SQL in java string format in SQL Editor

                                    ii.      Select the entire text

                                  iii.      Go to Editor -> Strip Code Statement

OR

                                   iv.            CTRL + P