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
Received on Thu Jun 01 2006 - 06:30:09 CDT
