Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

SQLcl command "cd" (change directory) with evaluation of environment variables

Justin WarwickAug 25 2021

I know that the start "@" operator does evaluate environment variables to determine full filepath to read from. It seems that the cd command does not. Or is there some special syntax that I could use to achieve that?
What I've tried:

SQLcl: Release 20.4 Production on Wed Aug 25 08:29:51 2021
username@opsd1>cd $HOME/
CD-001: $HOME/ is not a directory.
username@opsd1>cd $HOME
CD-001: $HOME is not a directory.
username@opsd1>cd "$HOME"
CD-001: $HOME is not a directory.
username@opsd1>cd @$HOME
CD-001: @$HOME is not a directory.
username@opsd1>cd @HOME
CD-001: @HOME is not a directory.

Tried similar stuff on Windows, to no avail.

This post has been answered by User_H3J7U on Aug 27 2021
Jump to Answer
Comments
Post Details
Added on Aug 25 2021
5 comments
1,402 views