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:
| SQL | SQL * 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. |