M. RAVI SANKAR

• Feb 26th, 2006

 

 Q.1 What are the advantages and disadvantages, compared to the    standard SQL and SQL*plus ?
Q.2 when i type 'ed' or 'edit' in oracle i did n't presented by any editor,what is the problem?
Q.3  what is the difference between 11.5.7 and 11.5.10 versions of oracle applications

.

KAWOOYA JANAT

• Mar 9th, 2006

 

fine

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.

Jeremy

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

mrrichardson

 Profile Answers by mrrichardson 

• Jul 11th, 2010

 

Structured Query Language

SQL-
Is a language
keywords cannot be abbreviated

SQL *PLUS -
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