SQL - What is difference between SQL and SQL*PLUS?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 10 of 168

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.

Total Answers and Comments: 8

Last Update: August 10, 2007

Sponsored Links

Best Rated Answer

—

Submitted by: madhug56

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.

Above answer was rated as good by the following members:
vijay_agg

October 08, 2005 14:29:46

Tez K N V

RE: What is difference between SQL and SQL*PLUS?...

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

Is this answer useful? Yes | No

January 03, 2006 03:28:39

Sithu

RE: What is difference between SQL and SQL*PLUS?...

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

Is this answer useful? Yes | No

February 18, 2006 03:42:57

palanisamy

RE: What is difference between SQL and SQL*PLUS?...

simple to ask structure query lanaguage(Sql)

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

Is this answer useful? Yes | No

April 29, 2006 16:56:54

Ravi

RE: What is difference between SQL and SQL*PLUS?...

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

Is this answer useful? Yes | No

November 02, 2006 11:10:50

thumatinagaraju

RE: What is difference between SQL and SQL*PLUS?...

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

Is this answer useful? Yes | No

January 29, 2007 03:36:57

Rohan Deshpande

RE: What is difference between SQL and SQL*PLUS?...

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.

Is this answer useful? Yes | No

June 05, 2007 19:10:45

madhug56

Member Since: November 2005 Contribution: 13

RE: What is difference between SQL and SQL*PLUS?...

SQL