Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: character set?
"news.xtra.co.nz" <sohosoho_at_ZEROSPAMhotmail.com> wrote in message
news:FupK6.130$ia.14439_at_news.xtra.co.nz...
>
> SQL> SELECT * from props$;
> SELECT * from props$
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
>
>
> what else should i try?
> bryce
>
>
> "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3AFA2201.E709B5D9_at_exesolutions.com...
> > "news.xtra.co.nz" wrote:
> >
> > > hi
> > > (very novice oracle person here)
> > > how can i tell which chacacter set oracle is currently set to?
> > >
> > > because ;)
> > >
> > > ive an encrypter (COM) which i use to encrypt and decrypt passwords
etc
from
> > > asp
> > > works fine on my oracle DB here in NZ
> > > but on the clients oracle DB in New York, its not working properly
> > >
> > > Regards
> > >
> > > bryce
> >
> > If you have access to the data dictionary tables perform the following:
> >
> > SELECT *
> > FROM props$;
> >
> > Daniel A. Morgan
> >
>
>
select * from sys.props$
or
select * from nls_database_parameters
The results are determined by the NLS_LANG var in the registry of the client computer, or in the registry of the internet server.
Hth,
Sybrand Bakker, Oracle DBA Received on Thu May 10 2001 - 00:43:48 CDT