Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: var source_data varchar2(12)

Re: var source_data varchar2(12)

From: Maryann Atkinson <maryann_30_at_yahoo.com>
Date: Tue, 11 Nov 2003 14:49:33 -0800
Message-ID: <F001.005D6581.20031111144933@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US