Re: sqlplus question

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 1 Jun 2006 06:42:22 -0400
Message-ID: <MZ6dnccYGfEPWePZnZ2dnUVZ_tydnZ2d@comcast.com>

"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*Plus doesn't know that... you told it B is a substitution variable (which is allowed in a quoted string)

check out the SQL*Plus SET command and look up DEFINE variables -- you should get more familiar with those features of SQL*Plus before proceeding.

++ mcs Received on Thu Jun 01 2006 - 05:42:22 CDT