Start a new topic

Support for oracle sqlplus variables

[This topic is migrated from our old forums. The original author name has been removed]

It would be very helpful if dbvis would recognise Oracle sqlplus variables. Otherwise it is not possible to execute statements in dbvis from within a sql-script that usually runs in sqlplus which make use of sqlplus variables.

I have not been able to use the dbvis variables, as sqlplus variables use different strings for begin and end delimiter.

The start delimiter is '&' or '&&' (or any other character -> configurable).
The end delimiter is <whitespace>, <newline>, <single quote>, <dot>, etc. It would be possible to use <dot> only.
1 Comment

[This reply is migrated from our old forums.]

Re: Support for oracle sqlplus variables
Chris, I'll register this an enhancement request. Thanks! Roger