Re: Server character set

From: Arcangelo <arcangelo-c_at_yahoo.com>
Date: Wed, 25 Jun 2003 23:18:47 +1000
Message-ID: <3ef9a138$0$5430$afc38c87@news.optusnet.com.au>

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_at_yahoo.com> wrote in message news:3ef9858f$0$5434$afc38c87_at_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_at_intersystemsww.com> wrote in message
> news:3EF91892.5010201_at_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
> >
>
>

Received on Wed Jun 25 2003 - 08:18:47 CDT