Re: two simple questions

From: GHouck <hksys_at_teleport.com>
Date: Tue, 09 Jan 2001 23:16:56 -0800
Message-ID: <3A5C0C68.71B9@teleport.com>

gbiltz wrote:
>
> Could someone please be kind enough to explain the difference between PL/SQL
> and SQL PLUS ? And also the definition of " := " ?

Basically,

SQL*Plus is Oracle's version of the SQL language, with some extensions to the standard.

PL/SQL is an Oracle Procedural Programming language, which allows you to create functions, procedures, packages, objects, etc., and has most of the higher-level programming constructs (loops, if/then/else, parameters, return values, etc.) and which is maintained within the database itself.

":=" is the assignment operator (in PL/SQL), equivalent to "=" in the C language (for example). "=" (in PL/SQL) is the equality comparison operator:

X := 1.24; (assign 1.24 to X)

IF X = 1.24 THEN (test whether X equals 1.24) <do something>
END IF; Yours,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Wed Jan 10 2001 - 01:16:56 CST