What is difference between SQL and SQL*PLUS?

SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database. SQL is a language used to query the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query result, Set options, Edit SQL commands and PL/SQL.

Showing Answers 1 - 14 of 14 Answers

Tez K N V

  • Oct 8th, 2005

SQL is a language to interact with the database........

whereas SQL*PLUS   is a tool provided by Oracle Corp. to write down your SQL statements......


  • Jan 3rd, 2006

SQL is a language: Structured Query Language. It has been 'invented' by IBM.

SQL*Plus is a command line tool from Oracle Corp. to use the SQL language for
a given database.


  Was this answer useful?  Yes


  • Feb 18th, 2006

simple to ask structure query lanaguage(Sql)

Sql * Plus is commond line tool don't involve (DML,DCL,DDL) 

  Was this answer useful?  Yes


  • Apr 29th, 2006


SQL is a language defining what you want to do ...when you want to do something ... where do you do what you want to do...

in otherwords SQL*PLUS is the "environment" where you can actually type your commands to perform queries and see the results in the same environment itself.

correct me if iam wrong

  Was this answer useful?  Yes


  • Nov 2nd, 2006

hisql is structured quiery language ..sql plus is an interfacing tool or medium thouh sql statements will be passed to the oracl server..sql keyword's cann't be abbrivated where as sql plus commands can be abbrivated ..sql statements go to buffer to oracle server where as sql plus commands act on the retrived results for generating formatted reports,,sql plus is oralce propritory ..and sql is a language can be used with any others languages or platforms.bye friends

Rohan Deshpande

  • Jan 29th, 2007

Structured Query Lanaguage(SQL) is a command language to communicate with oracle server.whereas SQL*PLUS is an oracle tool that recognises and submits sql statements to the oracle server for execution.

  Was this answer useful?  Yes


  • SQL is a language that can communicate with Oracle server to access the data.
  • It is based on ANSI standards.
  • There is no continuation character.
  • Keywords cannot be abbreivated.
  • Use functions to manipulate the data.

  • It recognises SQL statement and sends them to the server.
  • Is an Oracle properitory.
  • There is a continuation character.
  • Keywords can be abbreviated.
  • Use commands to manipulate the data.


  • Aug 10th, 2007

SQL keywords cannot be abbrevated but SQL*PLUS keywords can be? abbrevated.

  Was this answer useful?  Yes

SQL stands for structured query language, which provide a communication interface between user and database.

isql*plus is a environment which provide a communication interface between system and user.

  Was this answer useful?  Yes

Kranthi swaroop

  • Dec 2nd, 2011

SQL is a Structure Query language. Where we build queries to communicate with Oracle server to Access the Data.


SQL * Plus is Command Line Tool or Interface which will reads the query or recognises the sql Statement and sends to Server.

For Example,

Think (SQL Statement) like a Packet, to move a Packet we need a Interface think (SQL*Plus).Hope, U got an idea..

If Iam Wrong.. Kindly tell me..

Nitisha Agarwal

  • Nov 5th, 2012

ur r absolultely right thanks for answer

  Was this answer useful?  Yes


  • Jun 12th, 2015

SQL is a data base language used for storing and retrieving data.where SQL*plus is a tool is used for write sql ,pl/SQL commands on that tool.

  Was this answer useful?  Yes


  • Nov 4th, 2015

Simply put, like a command prompt in Windows Operating system, we have SQL PLUS tool in Oracle DBA.

  Was this answer useful?  Yes


  • May 12th, 2016

PL/SQL provides the capability of the programming language and supports the above mentioned list. It also supports running of SQL statements inside the PL/SQL blocks. SQL provides access to the database for retrieving data from the objects. However SQL does not have the programming capabilities.

  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