Connect #sqlcl to #oci Autonomous database #quicktip.

I love working from the command line. Now, don’t get me wrong, I spend quite a bit of time in #sqldeveloper and love it.

Quite a few of my scripts reside on my laptop where I can use my editor of choice to write them. Because of this, I normally run my scripts straight out of sqlcl. It’s quite simple.

First off, you’ll need to download the wallet from oci.

You’ll need to enter a password for you wallet and download it.

Copy the wallet to a location of your choice.

Start up sqlcl, set cloudconfig to point to the wallet you just downloaded.

set echo on
set cloudconfig C:\work\owi-database-wallets\
conn rlockard[projects]@avdf0test0db_high
This entry was posted in infosec. Bookmark the permalink.