RE: Languages

From: Bort, Guillermo <>
Date: Thu, 9 Oct 2008 07:49:58 -0500
Message-ID: <>

This seems to be a NLS environment issue. Try setting nls_date_format and/or nls_language.


Guillermo Alan Bort
DBA / DBA Main Team

EDS, an HP company

-----Original Message-----

From: [] On Behalf Of Mário Gamito Sent: Thursday, October 09, 2008 9:23 AM To:
Subject: Languages


I've installed Oracle 10g in Windows, and it installed both English and Portuguese languages.
All the software is English writen. The feedback, errors and warnings are in portuguese. It's not to my liking, but I can live with that.

The problem is in the SQL itself.

For example, if I try to get the day after FRIday, I get an error with this statement:


because, FRI(day) is for English. The statement runs smoothly if I change "FRI" for "SEX" which are the first three letters for Friday in portuguse (sexta).

Does anyone knows how can I set the whole system to be in English ?

Any help would be appreciated.

Warm Regards,
Mário Gamito

-- Received on Thu Oct 09 2008 - 07:49:58 CDT

Original text of this message