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

Home -> Community -> Usenet -> c.d.o.misc -> Re: DIFFERENCE.....

Re: DIFFERENCE.....

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Mon, 12 Oct 1998 11:52:38 +0100
Message-ID: <6vsn0i$m7j$1@schbbs.mot.com>


When used within SQL*Plus a single & will prompt you for a value on each occasion. Use of double && will only prompt you on the first, i.e,. use existing value. At least that's how I use it

--
Alan D. Mills

dvsingh1_at_my-dejanews.com wrote in message <6vsh4e$get$1_at_nnrp1.dejanews.com>...
>Hello..
>
> Could U please tell me the differences betwn..
>
> 1 '&variable_name' and '&&variable_name'
>
> 2 @filename and @@filename
>
>could U also tell when to use what....
>
>Thanks in Advance....
>Digendra
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Oct 12 1998 - 05:52:38 CDT

Original text of this message

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