Diffrence between SQL and SQL*Plus
SQL :
- SQL is Language.
- It is Based on ANSI Standard SQL.
- It is entered into the SQL buffer on one or more lines.
- SQL can not be abbreviated.
- It uses a termination character to execute command immediately.
- SQL statements manipulate data and table definition in the database.
SQL*Plus :
- SQL*Plus is an environment.
- It is oracle proprietary interface for executing SQL statements.
- It is entered one line at a time,not stored in the SQL buffer.
- SQL*Plus can be abbreviated.
- It does not require termination character.Commands are executed immediately.
- It does not allow manipulation of values in the database.

About
Tags
Popular


0 comments:
Post a Comment