What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

Showing Answers 1 - 5 of 5 Answers


  • Mar 9th, 2006


  Was this answer useful?  Yes

Asim Jamal

  • Apr 13th, 2006

Standard SQL:

SQL is a very simple and  powerful database access language. It is a nonprocedural language and the  user describe in SQL what he wants to do and the SQL language compiler automatically generates a procedure to navigate the database and perform the desired and  reqired task.

IBM Research developed and defined SQL, and ANSI/ISO has defined SQL as the standard language for relational database management systems. The SQL implemented by Oracle Corporation for Oracle is fully compliant  with the ANSI/ISO 1992 standard SQL data language.

Oracle SQL includes many versions to the ANSI/ISO standard SQL language, and Oracle tools and applications provide additional commands. The Oracle tool SQL*Plus allow you to execute  ANSI/ISO standard SQL statement against an Oracle database, as well as additional commands or functions .

So , using SQL*Plus is more advantageous than Standard SQL becuase we have got more facilities while using Standard SQL is core language.

  Was this answer useful?  Yes


  • Aug 24th, 2007

SQL*Plus is a client program and interactive interpreter designed for interacting with Oracle databases. SQL is a standard data access language used to describe data access to a variety of databases. They have nothing to do with each other.

"SQL*Plus" is *not* the term for Oracle's SQL extensions or interpretations of the standard. It's *not* a synonym for PL/SQL. This would be the sort of trick question I might ask (if I asked trick questions) to see if someone can be taken seriously. It's a troll, in other words.

  Was this answer useful?  Yes

Structured Query Language

Is a language
keywords cannot be abbreviated

More complex than SQL
Is a command line tool propietary to Oracle where you can run both SQL and PL/SQL statements
Excellent reporting capabilities
Less memory requirements

Not a standard query language must have the entire Oracle software installed before using
keywords cannot be abbreviated

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