SQL*Plus Tutorial


The differences between SQL * Plus commands and SQL commands

SQL * Plus Commands that are significant:
- not asking the end character;
- require a continuation character if the order is greater than one line;
- are not submitted in the SQL buffer;
- do not allow manipulation of the data in the database;
- keywords may be abbreviated.



Differences between SQL and SQL * Plus:

SQLSQL * Plus
It is a language of communication with your Oracle server for accessing data. Recognize SQL statements and their transfer to your Oracle server.
Is based on the ANSI SQL standard. Is an interface specifies the Oracle system for executing SQL statements.
Process the data and defines the objects from the database. Not permit the processing of information in the database.
Does not have a continuation character. Supports the "-" as the character still commands written on several lines.
The instructions cannot be abbreviated. Commands may be abbreviated.
Use the functions to perform formatting. Use the commands for formatting data.
The end of a command is ";" Requires no end character of a command.