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

Home -> Community -> Usenet -> c.d.o.server -> Re: quicky

Re: quicky

From: Mike Morgan <mmorgan1_at_mail.tds.net>
Date: Mon, 30 Aug 1999 01:03:16 GMT
Message-ID: <oLky3.233$Pv1.38139@ratbert.tds.net>


Use two ampersands:
eg:
select * from A, B where apk = &1 and bpk = &&1

Doug Cowles wrote in message <37C9D3AE.D44B83AB_at_bigfoot.com>...
>What's the syntax for placing a variable in a sql command so I don't
>have
>to enter it twice?
>select * from A, B where apk = &1 and bpk = &1
>
>
>
Received on Sun Aug 29 1999 - 20:03:16 CDT

Original text of this message

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