Re: sqlplus question

<sybrandb_at_yahoo.com> wrote in message
news:1149161409.392470.108030_at_i39g2000cwa.googlegroups.com...
:
: Mark C. Stock wrote:
: > "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)
: >
: This just demonstrates how lousy the parser is in sql*plus, evidently
: not following the BNF method in parsing.
:
: --
: Sybrand Bakker
: Senior Oracle DBA
:

???

i believe it's actually designed to work that way with lexical substitutions so that scripts like the following can be used:

insert into emp (empno,ename) values (&empno, upper('&ename'))

++ mcs Received on Thu Jun 01 2006 - 06:37:41 CDT