Re: SQL, SQL PLUS, PL/SQL

On 22 Aug 2000, at 7:01, Rusnak, George A. II wrote:

Date sent:      	Tue, 22 Aug 2000 07:01:49 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
From:           	"Rusnak, George A. II" <rusnakg_at_SDCL.LEE.ARMY.MIL>
Subject:        	SQL, SQL PLUS, PL/SQL

Here is a rough start, maybe the experts can elaborate, correct, etc?

> I was recently asked, what is the difference between

>SQL,
"Structured Query Language": generically, there are industry standards for SQL. I think Oracle mostly complies.

note: the language for a RDBMS is independent of "relational theory". eg, Ingres had an "alternative" language to SQL.

>SQL Plus

Oracle's utility for running SQL, it contains some "oracle specific" language elements that are additions to stadard SQL (eg, "decode"?).

>and
> PL/SQL.
"PL" = "Procedural Language"

"Loop", "If-then-else", etc.

You should be able to find precise definitions of SQL-plus and PL/SQL at Oracle's web site, possibly look for pertinent product documentation at http://technet.oracle.com , such as "concepts" for Oracle8i, and/or the SQL-plus manual that comes with 8i. Received on Tue Aug 22 2000 - 16:22:47 CDT