Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Alias with Sqlcl in path with spaces

Erik van RoonNov 4 2019

I run into a **small** issue with alias command in SQLcl,

Running on windows.

Seen in versions 19.1 and above, not in 18.3 and below.

If SQLcl is located in a path without spaces everything works as expected

Type in the alias command and you get a list of your currently defined aliases

But if SQLcl is in a path WITH spaces things change.

Now the first time the alias command is used an error message is shown saying it can't find the path to the "dbtools-common.jar" file, because it replaced the space with a "%20".

(see screenshot below).

Subsequent executions of alias no longer show this error message.

The funny part is: the alias command in this situation shows 86 extra built-in aliases that are not displayed when SQLcl is in a path without spaces.

The extra aliases can be viewed with "alias list" and can be executed (also when in path without spaces).

SQLcl in a path WITH space ("E:\sqlcl kopie\")

SQLcl with space.jpg

SQLcl in a path WITHOUT space ("E:\sqlcl\")

SQLcl without space.jpg

Comments

Post Details

Added on Nov 4 2019
0 comments
315 views