Oracle Tips by Burleson

Oracle 10g Oracle Date, Number, and Monetary Formats in OGS

Another function of OGS is to provide formatting classes that support date, number, and monetary formats that use Oracle conventions for use in Java applications. These OGS APIs also provide for the additional locale formats and information introduced in Oracle Database 10g, such as the long date, number, and monetary formats for a given locale.

Oracle Binary and Linguistic Sorts in OGS

Oracle internally provides support for binary, monolingual, and multilingual linguistic sorts in the database. In Oracle Database 10g, these linguistic sorts have been expanded to provide case-insensitive and accent-insensitive sorting and searching capabilities inside the database. By using the OGS - OraCollator class, Java applications can sort and search for information, based on the latest Oracle binary and linguistic sorting capabilities.

Normalization (decomposition of characters) can be an important part of sorting. The Unicode standard is the basis for the composition and decomposition of characters, so sorting, which uses normalization, depends on the Unicode standard. OGS provides an OraNormalizer class based on the Unicode 3.2 standard. The OraNormalizer class contains methods to do composition and decomposition.

The following four monolingual linguistic sorts are not supported in OGS. They are:

• Thai Telephone
   

• Thai Dictionary
   

• Japanese
   

• Canadian French

To obtain similar sorting results, you can also use their multilingual counterparts which are:

• THAI_M
   

• JAPANESE_M
   

• CANADIAN_M

Next, let's look at Internet Services.

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm