Re: ORA-00911: invalid character

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)