Server character set

[Tanel Poder]

Hi!

I'd rather use:

select value from nls_database_parameters where parameter =
'NLS_CHARACTERSET';

Tanel.

"Abhijith" <abhijith@nomail.com> wrote in message
news:3EF6E95D.2060009@nomail.com...

> try
> SELECT nls_charset_name(nls_charset_id('CHAR_CS')) FROM dual
>
> Abhijith.
>
> Holger Heidenbluth wrote:

> > Hi all,
> >
> > can anybody tell me how I can retrieve the character set
> > name that once has been used to create the database?
> >
> > Thanks
> > Holger
> >
> >

>

[Arcangelo]

Or even simpler: select * from database_properties;

;-*


"Tanel Poder" <tanel@@peldik.com> wrote in message
news:3ef78e6f_1@news.estpak.ee...

> Hi!
>
> I'd rather use:
>
> select value from nls_database_parameters where parameter =
> 'NLS_CHARACTERSET';
>
> Tanel.
>
> "Abhijith" <abhijith@nomail.com> wrote in message
> news:3EF6E95D.2060009@nomail.com...

> > try
> > SELECT nls_charset_name(nls_charset_id('CHAR_CS')) FROM dual
> >
> > Abhijith.
> >
> > Holger Heidenbluth wrote:

> > > Hi all,
> > >
> > > can anybody tell me how I can retrieve the character set
> > > name that once has been used to create the database?
> > >
> > > Thanks
> > > Holger
> > >
> > >

> >

>
>

[Arcangelo]

Incidentally:

SQL> select * from database_properties;

PROPERTY_NAME
------------------------------
PROPERTY_VALUE
----------------------------------------------------------------------------
----
DESCRIPTION
----------------------------------------------------------------------------
----
DICT.BASE
2
dictionary base tables version #

DEFAULT_TEMP_TABLESPACE
TEMP
Name of default temporary tablespace

DBTIMEZONE
-07:00
DB time zone

NLS_LANGUAGE
AMERICAN
Language

NLS_TERRITORY
AMERICA
Territory

NLS_CURRENCY
$
Local currency

NLS_ISO_CURRENCY
AMERICA
ISO currency

NLS_NUMERIC_CHARACTERS
..,
Numeric characters

NLS_CHARACTERSET
AL32UTF8
Character set

NLS_CALENDAR
GREGORIAN
Calendar system

NLS_DATE_FORMAT
DD-MON-RR
Date format

NLS_DATE_LANGUAGE
AMERICAN
Date language

NLS_SORT
BINARY
Linguistic definition

NLS_TIME_FORMAT
HH.MI.SSXFF AM
Time format

NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
Time stamp format

NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
Time with timezone format

NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
Timestamp with timezone format

NLS_DUAL_CURRENCY
$
Dual currency symbol

NLS_COMP
BINARY
NLS comparison

NLS_LENGTH_SEMANTICS
BYTE
NLS length semantics

NLS_NCHAR_CONV_EXCP
FALSE
NLS conversion exception

NLS_NCHAR_CHARACTERSET
AL16UTF16
NCHAR Character set

NLS_RDBMS_VERSION
9.2.0.1.0
RDBMS version for NLS parameters

GLOBAL_DB_NAME
GEN92.PICTON.COM
Global database name

EXPORT_VIEWS_VERSION
8
Export views revision #


25 rows selected.

Just so you know...

;-)


"Arcangelo" <arcangelo-c@yahoo.com> wrote in message
news:3ef9858f$0$5434$afc38c87@news.optusnet.com.au ...

> That would be because it is a new view in 9i.
>
> You didn't specify your version.
>
> So I had to guess.
>
> ;-)
>
>
> "Avi Abrami" <aabrami@intersystemsww.com> wrote in message
> news:3EF91892.5010201@intersystemsww.com...

> > Arcangelo wrote:

> > > Or even simpler: select * from database_properties;

> >
> > Arcangelo,
> > It doesn't work for me :-(
> >
> > SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 25 06:30:21 2003
> >
> > (c) Copyright 2000 Oracle Corporation. All rights reserved.
> >
> >
> > Connected to:
> > Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
> > JServer Release 8.1.7.4.0 - Production
> >
> > SQL> select * from database_properties;
> > select * from database_properties
> > *
> > ERROR at line 1:
> > ORA-00942: table or view does not exist
> >

>
>