Re: sql - pl/sql - sql*plus

SQL - Structured Query Language - The programming language used to review and modify information in your database. Usually SQL92/99 compliant commands that will work with most compliant databases such as Oracle, MS SQL Server, MY/SQL and the like.

PL/SQL - Prcedure Language/Structured Query Lanquage - This is a mostly proprietary Oracle extension to SQL that allows for more complex commands and actions. Microsoft uses T-SQL (Transactional SQL) as an equivelant product for extending MS SQL Server.

SQL*Plus - One of many Oracle tools to run SQL and PL/SQL commands against a database. It can be used to query, update and delete data from your database. It has some reporting functionality and can be used from a command prompt in Windows to run batch scripts. This is a very limited description, but that cover the very basics.

"ad mannien" <amannien_at_westbrabant.net> wrote in message news:999883570.532501_at_news.knoware.nl...
> I am new to Oracle.
>
> Can someone explain to me the difference between:
> Oracle SQL
> Oracle PL/SQL
> Oracle SQL*Plus
>
> Thans,
> ad
>
>
Received on Fri Sep 07 2001 - 14:12:22 CDT