Hi,

Try SELECT * FROM nls_database_parameters;

Regards,

James

--- Edwin Uy
<oracledba-ezmlmshield-x8166612.[Email address protected]
wrote:
> HI all,
>
> How do I check what is my db character set? Whether
> it is WE8ISO8859P!
> or US7ASCII or whatever ... thought it should show
> when I do a show
> parameter nls, but not getting that info doing that
> ...
>
> Cheers,
>
>
> EDWIN ONG UY
> \\|//
> (o o)
> ^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^
>
> "Choose a job you love, and you will never have to
> work a day in your
> life." --Confucius
> "How do I work? I grope." -- Albert Einstein
> "Experience is the best teacher, enrolling in the
> class is the biggest
> problem." -- Anonymous
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here:
> http://tahiti.oracle.com
> To unsubscribe: see
> http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>




__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

Oracle LazyDBA home page