Tuesday, August 11, 2009

TOAD - file extensions and highlighting.

It’s been bugging me for a while that *.vew files were opening in TOAD without keywords being highlighted as they were in *.vw files.

This can be fixed by adding the *.vew file-extension here:

View=> Toad Options=>Editor=>Behaviour

There is a “languages” frame in the middle at the bottom of the page. Select “PL/SQL” from the drop-down box and click on the button with three dots in it.

In the “General” tab on the form that opens, you can add file extensions, so add VEW, SPS, SPB and anything else you want formatted.

Hope this is of use.