Re: ORA-00911: invalid character

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sun, 13 Apr 2003 15:34:17 +0200
Message-ID: <tppi9vkolre8mrkide8dtom4rqfthven0n@4ax.com>

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

>Dave,
>Tried 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` AS casecr
> 5* from customers
>SQL> /
> case credit_limit when 100 then `low`
> *
>ERROR at line 2:
>ORA-00911: invalid character
>
>
>SQL>
case is a 9i thingy. Please check the compatibility parameter of your database.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Apr 13 2003 - 08:34:17 CDT