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 Copyright (c) 1982, 2018, Oracle. All rights reserved. Enter password: password Last Successful login time: Tue Jan 09 2018 11:18:45 -08:00 Connected to: Oracle Database - 64bit Production 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.