Re: ORA-00911: invalid character

From: sdg <nospan_at_noway.org>
Date: Sun, 13 Apr 2003 12:48:50 GMT
Message-ID: <3E995C15.F4887BD0@noway.org>

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

Andy Hassall wrote:

> 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)
Received on Sun Apr 13 2003 - 07:48:50 CDT