Re: ORA-00911: invalid character

Andy

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

>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 wrote:

> On Sun, 13 Apr 2003 14:43:24 GMT, sdg <nospan_at_noway.org> wrote:
>
> >That's what I thought I was using the first time. Single quote... above double
> >quote on keyboard.
> >double quote "
> >single quote '
> >
> >Correct?
>
> That's the correct character now, its loation depends on your keyboard -
> sounds right for a US layout one (it's below @ on the right hand side on mine,
> UK layout).
>
> The character you were using in the first place wasn't that, it looked like
> one half of MS Word's 'smart quotes'.
>
> --
> 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 - 16:45:08 CDT