What is the difference between SQL and SQL plus?

Showing Answers 1 - 12 of 12 Answers

Ramesh

  • Aug 26th, 2006
 

SQL is a language to get information out of database name ;SQL plus is the name of excutable that implements the same ;You could name the implementation at will.

  Was this answer useful?  Yes

Raja

  • Sep 7th, 2006
 

1

  Was this answer useful?  Yes

SQL(Structured Query Language) This is a set of commad that is followed by all the DataBase(Oracle,Ms-SQL,Teradata,My-sql....)

And SQL plus is a software comes with oracle to execute that sql queries. 

  Was this answer useful?  Yes

harshali

  • May 15th, 2007
 

SQL is a Structured Query Language
SQL Plus is  an environment

  Was this answer useful?  Yes

Sql is the command line prompt, where we can enter commands of DDL,DML and
DCL to perform transaction in database. i.e


sql> select * from dual;

sql> select count(*) from dual;


SQL*Plus is the command line sql and PL/SQL language interface that ships
with the oracle database client and server. It can be used interactively or by
the script of coding.

SQL*Plus is used by the DBA?s and developers to interact with the oracle
database.

So we can say sql*Plus is an Interface by that DBA?s can interact with database
and SQL is the command line prompt where user can enter commands to execute
certain tasks.

  Was this answer useful?  Yes

vizaik

  • Aug 14th, 2007
 

In layman terms,
SQL is a language to query a database.
SQL plus is an editor (provided with oracle) to write/execute sql commands.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions