How to "set define '~'" in TOAD

[Rob.Beelen]

I want to use another character than & to prefix my variables in scripts.

How can I change the & to ~ (in SQL-plus we use "set define '~'" )

With kind regards

[Gary.Jerep]

Hey Rob, welcome to the Toad forums.

Haven't tested it yet, but would Toad's SQLPlus execution mode help here... e.g. if you're using these ~ -prefixed variables mostly in SQLPlus anyway?

[JohnDorlon]

Toad should follow the same "SET" command as SQL Plus.

[Rob.Beelen]

Thx John,

When using F5 and run as script it works fine, but with F9 (or Formatter ctrl+shift+F) toad does not work as expected (with & it works better)

[JohnDorlon]

Oh, ok. We don't have a way to set that. I'll log it as an enhancement request.

[Rob.Beelen]

Great, Please keep me updated when it's solved

[JohnDorlon]

By the way, this option may help you. Right-click in the editor to set it.