SQLcl is a new enhanced SQL command-line implemented in Java. Your Oracle Database Exadata Express Cloud Service supports connecting to your PDB from SQLcl.
Download and Set up Oracle SQLcl
Oracle SQLcl provides a powerful command-line interface (CLI) for authoring SQL and PL/SQL on databases. This section describes the download requirements and prerequisites for Oracle SQLcl and where to find the latest setup instructions.
Requirements and Prerequisites
The functionality described here uses the Oracle SQL Developer Command-Line (SQLcl), version 17.4 (current version) or later running on Java Runtime Environment (JRE) version 8 update 161 or later.
Network connections between SQLcl and Exadata Express require Java unlimited strength encryption. Verify that SQLcl is running on JRE version 8 update 161 or later, which provides unlimited strength encryption by default.
Configure Oracle SQLcl Cloud Connection
Oracle SQLcl can be configured to connect to Oracle Database Exadata Express Cloud Service, as a regular database connection using the client credentials downloaded from the Exadata Express service console.
To create an Oracle SQLcl cloud connection:
- Download the Client Credentials zip file from the Exadata Express service console. See Enable Oracle Net Services (SQL*Net) Access for Client Applications for information on downloading the Client Credentials.
Note:Copy the Client Credentials zip file into
~/sqlcl/bindirectory, to avoid including the complete file path in step 3 below.
- Navigate to the
sqlcl/bindirectory from where you unzipped the SQLcl installation files, and run
sql /nolog, to startup Oracle SQLcl.The Oracle SQLcl starts displaying the date and time, the SQLcl version and copyright information, before the SQLcl prompt appears.
D:\PDB Service\SQL CL\sqlcl-no-jre-latest\sqlcl\bin>sql /nolog SQLcl: Release 220.127.116.11.160.2007 RC on Fri Dec 08 12:18:07 2017 Copyright (c) 1982, 2017, Oracle. All rights reserved. SQL>
- At the SQLcl prompt, type
set cloudconfig <name of your wallet zip file>, and press the Enter key.
Note:Include the complete file path, if you have not copied the Client Credentials zip file to the
- Enter the Password provided for downloading the Client Credentials from the Exadata Express service console, and press the Enter key.
SQL> set cloudconfig client_credentials.zip Wallet Password: ************ Using temp directory:C:\Users\USER~1.ORA\AppData\Local\Temp\oracle_cloud_confi g6707346342028726502
- To connect to the Exadata Express, type
conn <username>/<password>@<servicename>, and press the Enter key. The
passwordare the credentials of your database account.You should now be connected to Exadata Express.
SQL> conn pdb_admin/password@dbaccess
Note:The example above uses the administrator user credentials to connect to the database. These are specified as part of the service creation in the cloud portal.
Invoke SQLcl from Oracle Developer Cloud Service
You can configure build steps in Oracle Developer Cloud Service to invoke SQL statements using SQLcl, a powerful command-line utility for managing and querying Oracle Database. The Invoke SQLcl build step now allows you to connect to Oracle Database Exadata Express Cloud Service.