Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: var source_data varchar2(12)
Got it Tim, thanks.
maa
At 05:04 PM 11/11/2003, you wrote:
>Maryann,
>SOURCE_DATA is a SQL*Plus variable, declared using the VAR
>(a.k.a. VARIABLE) command. It can be referenced inside the
>PL/SQL block and then used by SQL*Plus commands (such as
>PRINT) or SQL commands (such as SELECT) outside of the
>block.
>
>My guess is that it is being used for communicating data
>values into or out of the PL/SQL block.
>
>Hope this helps...
>
>-Tim
>
> > My original posting had a few lines truncated, so here I
> > go again:
> > I'm looking at a PL/SQL script that goes like this
> >
> > -- Header
> > var Source_Data VARCHAR2(12)
> >
> > DECLARE
> > Num1 NUMBER;
> >
> > BEGIN
> > Source_Data := '&1';
> >
> > What's the purpose of having a VAR statement in front or
> > Before of the Declare section? Is it used for
> > bind-variables, is that what it is?
> > thx
> > maa
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net --
> > Author: Maryann Atkinson
> > INET: maryann_30_at_yahoo.com
> >
> > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com San Diego, California --
> > Mailing list and web hosting services
> > ----------------------------------------------------------
> > ----------- To REMOVE yourself from this mailing list,
> > send an E-Mail message to: ListGuru_at_fatcity.com (note
> > EXACT spelling of 'ListGuru') and in the message BODY,
> > include a line containing: UNSUB ORACLE-L (or the name of
> > mailing list you want to be removed from). You may also
> > send the HELP command for other information (like
> > subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Tim Gorman
> INET: tim_at_sagelogix.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson INET: maryann_30_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Nov 11 2003 - 16:49:33 CST