Re: ORA-00911: invalid character

That's what I thought I was using the first time. Single quote... above double quote on keyboard.
double quote "
single quote '

Correct?

Andy Hassall wrote:

> On Sun, 13 Apr 2003 12:48:50 GMT, sdg <nospan_at_noway.org> wrote:
>
> >Ok, so I tried the following, same result.
> >
> >SQL> l
> > 1 SELECT cust_last_name,
> > 2 case credit_limit when 100 then `low`
> > 3 when 5000 then `high`
> > 4 else `Medium` END
> > 5* from customers
> >SQL> /
> >case credit_limit when 100 then `low`
> > *
> >ERROR at line 2:
> >ORA-00911: invalid character
>
> Now you're using `, which is another wrong quote (that's a backtick). It's
> plain single quote ' for quoting strings (ASCII code 39 decimal).
>
> --
> Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
> Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Received on Sun Apr 13 2003 - 09:43:24 CDT