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!

Using environment variables in sqlcl

John Li Yim [VND]Jan 7 2020 — edited Jan 14 2020

How can we reference environment variables in sqlcl?

We have a bunch of sql scripts that call other sql scripts using a environment variables

eg (Windows OS).

@%sql_path%/dba.sql

Using sqlcl, this does not work.

Any idea?

John

Comments

Post Details

Added on Jan 7 2020
17 comments
2,259 views