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: sqlplus question

Re: sqlplus question

From: Vladimir M. Zakharychev <bob--nospam--_at_dynamicpsp.com>
Date: Thu, 1 Jun 2006 14:44:31 +0400
Message-ID: <e5mgei$kng$1@hypnos.nordnet.ru>

"freedba" <p.hirth_at_gmail.com> wrote in message news:1149158326.848926.168260_at_j55g2000cwa.googlegroups.com...
> Hi,
> I would like to execute :
>
> SQL>select services.cod_etab from paie.services where cod_etab in
> ('B&B');
> Enter value for b:
>
>
> but b is not a variable, 'B&B' is a string !!!
>
> how can i do?
>

SQL> set define off
SQL> your query goes here

-- 
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com 
Received on Thu Jun 01 2006 - 05:44:31 CDT

Original text of this message

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