24 Apr 2013

Diffference between SQL and SQL*Plus

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.

Written by

Hello,Visitor..!

0 comments:

Comments

© 2013-2016 ITTechnocrates. All rights resevered. Developed by Bhavya Mehta