High-Performance Oracle Proven Methods for Achieving Optimum - download pdf or read online

By Ingram G.

Show description

Read Online or Download High-Performance Oracle Proven Methods for Achieving Optimum Performance and Availability(First Edition)(720) PDF

Best databases books

Download e-book for kindle: The New Relational Database Dictionary: Terms, Concepts, and by C. J. Date

It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can continually come up over the right meanings of phrases, misunderstandings that may have a major influence at the luck of your database tasks. for instance, listed below are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating workforce, subscribe to dependency.

Additional resources for High-Performance Oracle Proven Methods for Achieving Optimum Performance and Availability(First Edition)(720)

Sample text

For example, "MM/DD/YY" occupies 12 bytes internally because there are three format elements, two one-byte strings (the two slashes), and the two-byte terminator for the format mask. The format for the value of this parameter cannot exceed 24 bytes. Note: The applications you design may need to allow for a variable-length default date format. Also, the parameter value must be surrounded by double quotes: single quotes are interpreted as part of the format mask. You can alter the default value of NLS_DATE_FORMAT by changing its value in the initialization file and then restarting the instance, and you can alter the value during a session using an ALTER SESSION SET NLS_DATE_FORMAT statement.

Year 2000 Issues Currently, the default date format for most territories specifies the year format as "RR" to indicate the last 2 digits. If your applications are Year 2000 compliant, you can safely specify the NLS_DATE_FORMAT using "YYYY" or "RRRR". If your applications are not yet Year 2000 compliant, you may wish to specify the NLS_ DATE_FORMAT as "RR". The "RR" format will have the following effect: Given a year with 2 digits, RR will return a year in the next century if the year is less than 50 and the last 2 digits of the current year are greater than or equal to 50; return a year in the preceding century if the year is greater than or equal to 50 and the last 2 digits of the current year are less than 50.

You can alter the default value of NLS_NUMERIC_CHARACTERS in either of these ways: ■ ■ Change the value of NLS_NUMERIC_CHARACTERS in the initialization file and then restart the instance. Use the ALTER SESSION SET NLS_NUMERIC_CHARACTERS command to change the parameter's value during a session. Monetary Parameters Oracle allows you to control how currency and financial symbols appear. 2-22 Oracle8i National Language Support Guide Monetary Parameters Currency Formats Many different currency formats are used throughout the world.

Download PDF sample

Rated 4.83 of 5 – based on 41 votes