User's Manual

Presenting Data following User's Locale Convention
8-8 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft
3 from employees
4 where last_name like 'C%'
5* order by last_name
EMPID Last Name
---------- -------------------------
187 Cabrio
148 Cambrault
154 Cambrault
119 Colmenares
110 Chen
188 Chung
6 rows selected.
Oracle Error Messages
The NLS_LANGUAGE parameter also controls the language of the database error
messages being returned from the database. Setting this parameter prior to submitting
your SQL statement will ensure that the language specific database error messages
will be returned to the application.
Consider the following server message:
ORA-00942: table or view does not exist
When the NLS_LANGUAGE parameter is set to French, the server message appears as
follows:
ORA-00942: table ou vue inexistante
See also: The "Working in a Global Environment" chapter in the
Oracle Database Express Edition 2 Day Developer Guide for more
discussion of globalization support features within Oracle Database
Express Edition.