SQLPlus

SQL * Plus is a tool that allows you to interact directly with the Oracle database.

SQL * Plus is an Oracle command line utility that allows users to interactively execute SQL and PL/SQL commands.

SQL * Plus enables you to manipulate blocks of SQL and PL / SQL formatting the query results, to copy data between tables and to execute SQL and PL / SQL.

Operations you can perform in SQL * Plus

– edit, save, load and execute SQL commands and PL/SQL blocks;
– list tables structures;
– access and transfer data between databases;
– implementation of functions for database managing: the users administration, namespaces table, operations management of archiving and recovery.

SQLPlus Commands
SQLPlus Substitution Variables
SQLPlus vs SQL

The SQLPlus commands are: