Re: using character like ä, ü in statements

You might try:

            select * from "TAB_ZÄHLER";

• Harri

"Lars Windels" <windels_at_swms.de> wrote in news:a7sb1e$bqf$06$1_at_news.t-online.com:

> Hello.
>
> I want to get a result from a table which contains ä,ü etc. in the
> tablename. With tools like toad i get a result. But if i want to get
> it from sqlplus an error occured.
> Has anybody a tip for me.
> The statement i want to use:
>
> select * from TAB_ZÄHLER;
>
> The error-message:
>
> ORA-00911: Ung³ltiges Zeichen

-- 
-----------------------------------------------------------------------
Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4