Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus question
"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.comReceived on Thu Jun 01 2006 - 05:44:31 CDT
![]() |
![]() |