What is SQL*Plus
SQL * Plus is is a product of Oracle in which the languages SQL and PL/SQL can be used.
SQL * Plus has its own command language for controlling the product and for formatting the results of the SQL interogtions.
SQL * Plus recognizes SQL commands and sends these commands to Oracle server for execution.
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.
PL/SQL is the procedural language of Oracle for writing applications and for the handling of data outside the database.
PL/SQL may include a subset of SQL commands, when access to the database is required. PL/SQL Reference: Pl Sql Tutorial and Oracle Tutorial.