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.
sql set echo on set cloudconfig C:\work\owi-database-wallets\avdf_test_db.zip conn rlockard[projects]@avdf0test0db_high