SQL*Plus is a command-line interface used to enter SQL commands. SQL*Plus connects to an Oracle database.
To install and configure the client and connect to the Autonomous Transaction Processing using SQL*Plus, do the following:
- Prepare for Oracle Call Interface (OCI), ODBC and JDBC OCI Connections. See Prepare for Oracle Call Interface (OCI), ODBC, and JDBC OCI Connections.
- Connect using a database user, password, and database service name provided in the
sqlplus sales_trans@atpc1_low SQL*Plus: Release 220.127.116.11.0 - Production on Wed Apr 3 15:09:53 2019 Version 18.104.22.168.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Enter password: Last Successful login time: Wed Apr 03 2019 14:50:39 -07:00 Connected to: Oracle Database 18c Enterprise Edition Release 22.214.171.124.0 - Production Version 126.96.36.199.0 SQL>
Note:The Oracle Wallet is transparent to SQL*Plus because the wallet location is specified in the
sqlnet.orafile. This is true for any Oracle Call Interface (OCI), ODBC, or JDBC OCI connection.