How to "set define '~'" in TOAD

Rob.Beelen · August 16, 2021, 6:20pm

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 · August 16, 2021, 6:50pm

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 · August 16, 2021, 6:51pm

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

Rob.Beelen · August 17, 2021, 2:47pm

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 · August 17, 2021, 2:50pm

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

Rob.Beelen · August 17, 2021, 2:59pm

Great, Please keep me updated when it's solved

JohnDorlon · August 18, 2021, 9:41pm

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