Difference between SQL and SQL*Plus
|
SQL
|
SQL*Plus
|
|
SQL is a language
|
SQL *Plus is an environment
|
| It is based on ANSI (American
National Standards Institute) standard
|
It is oracle proprietary interface for
executing SQL statements
|
|
It is entered into the SQL buffer on one
or more lines
|
It is entered one line at a time, not
stored in the SQL buffer
|
|
SQL cannot be abbreviated
|
SQL*Plus can be abbreviated
|
|
It uses a termination character to
execute command immediately
|
It does not require termination
character. Commands are executed immediately.
|
|
SQL statements manipulate data and
table definition in the database
|
It does not allow manipulation of
values in the database
|