Re: ORA-00911: invalid character

On Sun, 13 Apr 2003 00:58:41 GMT, sdg <nospan_at_noway.org> wrote:

>Below came from 92R SQL Plus Reference. Can someone give me a hand as to
>why I am getting
>the ORA-00911 error. I have tried to track down without success.
>
>
>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>
>
>
>SQL> /
>CASE credit_limit WHEN 100 THEN ’Low’
> *
>ERROR at line 2:
>ORA-00911: invalid character

 You've got strange quotes in there; your statement contains ’ when they should be '.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)