Print Thread
Template not replacing substition variables when inserting into editor
#57160 10/17/17 02:07 PM
Joined: Nov 2007
Posts: 18
B
Bart Offline OP
Member
OP Offline
Member
B
Joined: Nov 2007
Posts: 18
Is there a way to prevent pl/sql developer to raise/display dialogs for (&/&&) substitution variables.
I want those dialogs only when I execute the code from the SQL editor.

Maybe I am overextending the use of templates and I should use just files...but currently I use templates as a tools repository.

Re: Template not replacing substition variables when inserting into editor
Bart #57165 10/18/17 09:24 AM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
If you specify && in a template, it will not be interpreted as a substitution variable, and && will be inserted as &.

Consider the following template text:

select * from &&table

When using this template you will not be prompted for a substitution variable, and the following text will be inserted:

select * from &table


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.017s Queries: 14 (0.004s) Memory: 2.5003 MB (Peak: 3.0435 MB) Data Comp: Off Server Time: 2024-05-20 22:19:57 UTC
Valid HTML 5 and Valid CSS