DIFFERENCE BETWEEN SQL & SQL * PLUS
SQL & Vs. SQL * PLUS
As we all know, SQL is a language.
While SQL*Plus is a tool.
SQL is the query language used for communication with Oracle server to access and modify the data.
SQL* Plus is a command line tool with which you can send SQL queries to the server. Also, it can help you format the query result.
SQL is a language which is invented by IBM.
SQL * Plus is a tool to use SQL language for a database from Oracle corporation.
SQL can be simply used to ask queries, i.e. it involves DML, DDL and DCL.
SQL * Plus is command line tool which doesn’t involve DML, DDL and DCL.
In SQL, there is no continuation character..
Whereas, in SQL * Plus there is a continuation character.
Keywords cannot be abbreviated in SQL.
But keywords can be abbreviated in SQL*Plus.
SQL uses functions to manipulate the data.
SQL * plus uses commands to manipulate the data.
Hope you enjoyed this.. See you again with more updates..