SQL Plus Tutorial

SQL*Plus Tutorial

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.

The main pages are:
- sqlplus commands
- sqlplus connect
- sqlplus examples

SQL

SQL is the language used to access a database relational query, including Oracle.
SQL can be used by each Oracle tool, when access to the database is necessary. SQL Reference: TSQL and SQL Tutorial.

PL/SQL

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.

Other database tutorial sites: PostreSQL tutorial and MySQL tutorial.