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.



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.


SQLplus Tutorial Logo

Like SQL Plus Tutorial Facebook