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:

Accept
Append
Archive
Attribute
Break
Btitle
Change
Clear
Column
Compute
Connect
Connect As Sysdba
Copy
Define
Del
Describe
Disconnect
Edit
Execute
Exit
Get
Help
Host
Input
List
Password
Pause
Print
Prompt
Recover
Remark
Repfooter
Repheader
Run
Save
Set
Show
Shutdown
Spool
Start
Startup
Store
Timing
Ttitle
Undefine
Variable
Whenever Oserror
Whenever Sqlerror