Re: How to determine CHARACTER SET of Oracle 8 database?

From: <iolo_at_my-dejanews.com>
Date: Mon, 13 Jul 1998 14:33:01 GMT
Message-ID: <6od5qt$9l9$1@nnrp1.dejanews.com>

In article <6ockc2$od0$3_at_news-1.news.gte.net>, johnvue_at_gte.net wrote:
> I can issue the following query to find out the CHARACTER SET of an
> Oracle 7.x database.
>
> select substr(value$, 1, 17) as nls_characterset
> from props$
> where name = 'NLS_CHARACTERSET';
>
> However, the props$ table is not in Oracle 8. How do I get this
> information in Oracle 8?
>

Look in V$NLS_PARAMETERS instead of props$

Oliver Willandsen
European Commission
http://europa.eu.int

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 13 1998 - 09:33:01 CDT