Re: What is The different between PL/SQL and SQL*Plus?

On Wed, 12 Mar 2003 12:48:01 +0800, "Jay" <zaestayfk_at_yahoo.com> wrote:
>What is The different between PL/SQL and SQL*Plus?
>Can anyone give me some examples???

SQL*Plus is the command-line environment where you enter the PL/SQL commands. PL/SQL is what you'll see inside blocks like

BEGIN
...
END; and

CREATE PROCEDURE ...
...
BEGIN
...
END; SQL*Plus commands are mostly involved with formatting the output from SQL queries (because you can enter straight SQL commands in SQL*Plus). Things like the SET command let you set up page size, line length, and such things for long output listings. The DEFINE command lets you set up substitution variables that you use in SQL commands or PL/SQL blocks.

When you're in SQL*Plus, you need to be able to switch back and forth between the SQL*Plus, SQL, and PL/SQL command set. Perhaps for that reason, Oracle has an online quick reference that combines all 3 sets of commands:

http://otn.oracle.com/pls/db92/db92.sql_keywords

John Received on Wed Mar 12 2003 - 00:50:09 CST