7 Oracle Tools for Database Access

For many database operations you need SQL or PL/SQL access. Oracle Database tools like SQL Developer, SQLcl and SQL*Plus provide such access to JSON databases.

The following sections provide step-by-step instructions for setting up these tools.

Topics

• Connect with Built-In Oracle Database Actions
• Connect Oracle SQL Developer with a Wallet (mTLS)
• Connect Oracle SQLcl Cloud with a Wallet (mTLS)
• Connect SQL*Plus with a Wallet (mTLS)

• Connect with Built-In Oracle Database Actions
  You can access Database Actions from Autonomous JSON Database. Database Actions provides development tools, data tools, administration, and monitoring features for Autonomous JSON Database. Using Database Actions you can run SQL statements, queries, and scripts in a worksheet.
• Connect Oracle SQL Developer with a Wallet (mTLS)
  Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Autonomous Database.
• Connect Oracle SQLcl Cloud with a Wallet (mTLS)
  SQLcl is a command-line interface used to enter SQL commands. You can use SQLcl to connect to an Autonomous Database with client credentials configured (mTLS).
• Connect SQL*Plus with a Wallet (mTLS)
  SQL*Plus is a command-line interface used to enter SQL commands. SQL*Plus connects to an Oracle database.