background image
<< Dropping Triggers | Globalization Support Features >>
<< Dropping Triggers | Globalization Support Features >>

Working in a Global Environment

Working in a Global Environment 6-1
6
Working in a Global Environment
This chapter discusses how to develop applications in a globalization support
environment, and shows the use of Unicode programming using both SQL and
PL/SQL. Unicode programming enables you to write SQL and PL/SQL code that is
compatible with multiple languages.
This chapter contains the following sections:
Overview of Globalization
on page 6-1
Using NLS Parameter Values in the SQL Developer Environment
on page 6-4
Establishing a Globalization Support Environment
on page 6-7
Developing Globalized Applications
on page 6-27
Using Locale-Dependent Functions with NLS Parameters
on page 6-30
Overview of Globalization
Oracle Database globalization support enables you to store, process, and retrieve data
in native languages. It ensures that database utilities, error messages, and sort order,
plus date, time, monetary, numeric, and calendar conventions, automatically adapt to
any native language and locale.
Globalization support includes National Language Support (NLS) features. National
Language Support is the ability to choose a national language and store data in a
specific character set. Globalization support enables you to develop multilingual
applications and software products that can be accessed and run simultaneously from
anywhere in the world. An application can render content of the user interface and
process data in the native language and locale preferences of the user.
See Also:
Oracle Database Globalization Support Guide for a complete
discussion of globalization support with Oracle Database,
including setting up the globalization support environment
Oracle Database SQL Language Reference for information about date
and time formats
See Also:
Oracle Database Globalization Support Guide for a complete
discussion of globalization support with Oracle Database,
including setting up the globalization support environment