Connect SQLcl

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.

Topics

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.

Download and Setup

For download and setup instructions to set up Oracle SQLcl locally, see Oracle SQLcl documentation on the Oracle Technology Network: SQL Developer Downloads SQL Developer Command Line SQLcl Overview

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/bin directory, to avoid including the complete file path in step 3 below.
Navigate to the sqlcl/bin directory 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 17.4.0.16.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 ~/sqlcl/bin directory, earlier.

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<username> and password are the credentials of your database account.
You should now be connected to Exadata Express.
SQL> conn pdb_admin/password@dbaccess

Connected.SQL>

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.

Learn more about Oracle Developer Cloud Service. To invoke SQLcl and connect to Oracle Database Exadata Express Cloud Service, see Adding a Build Step that Invokes SQLcl in Using Oracle Developer Cloud Service.

Related Topics