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 Substitution Variables
SQLPlus vs SQL
The SQLPlus commands are: