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......

Sithu

• 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.

Sithu

palanisamy

• Feb 18th, 2006

 

simple to ask structure query lanaguage(Sql)

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

Ravi

• Apr 29th, 2006

 

Hi:

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

thumatinagaraju

• 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.

madhug56

 Profile Answers by madhug56 Questions by madhug56

• Jun 5th, 2007

 

SQL

• 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.

SQL*PLUS

• 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.
  

shakshi

• Aug 10th, 2007

 

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

ankitagujrati28

 Profile Answers by ankitagujrati28 

• Apr 30th, 2010

 

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.

Kranthi swaroop

• Dec 2nd, 2011

 

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

and

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

mahesh

• 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.

Das

• Nov 4th, 2015

 

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

qptopm

 Profile Answers by qptopm 

• 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.