Re: strange sql command

This was answered a fe times before.

set define off

Hth.

Ted
On Thu, 22 Mar 2001 07:54:53 +0100, "Marcel Stör" <marcel.stoer_at_complementa.ch> wrote:

>hi folks
>
>if i try to execute the following command oracle asks to enter the value for
>mid, since it obviously interpretes it as a keyword or built-in function:
>
>select oid, pid, p2maincat from t_product where p2maincat = 'Equity
>Switzerland Small & mid Cap';
>
>how to avoid this? i need to tell the database even more clearly that
>everything right from the = is one single string.
>
>cheers, marcel
>
>
>
>

EMail: knijff_at_bigfoot.com Received on Thu Mar 22 2001 - 01:46:08 CST