Re: ORA-00911: invalid character

On Sun, 13 Apr 2003 21:45:08 GMT, dba <nospan_at_noway.nohow.org> wrote:

>That's the exact character I used in my initial example. I don't get your point.

 No, it's not; you've posted two distinct queries with two types of quote, neither of which are the right one.

 Initially:

>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

 Then:

>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

 The correct quote is ', as in the example in the docs.

 Whether you can see the difference probably depends on your font, but here they are together, first the two you posted then the right one:

’ ` '

 The first quote you've posted is apparently character code 146 according the editor I've just pasted it into; not 39 as for the plain single quote.

 The original from the docs:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/expressions5a.htm#1033453

SELECT cust_last_name,

   CASE credit_limit WHEN 100 THEN 'Low'    WHEN 5000 THEN 'High'
   ELSE 'Medium' END
   FROM customers;

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