Read Online or Download Oracle Applications DBA Field Guide (19) PDF
Best databases books
This ebook brings the entire parts of database layout jointly in one quantity, saving the reader the time and price of constructing a number of purchases. It consolidates either introductory and complex themes, thereby masking the gamut of database layout technique ? from ER and UML options, to conceptual information modeling and desk transformation, to storing XML and querying relocating items databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an software programming interface (API) that enables functions written in С or C++ to have interaction with a number of Oracle database servers. OCI offers your courses the potential to accomplish the total diversity of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.
Oracle Warehouse Builder 11g: Getting Started
This easy-to-understand instructional covers Oracle Warehouse Builder from the floor up, and faucets into the author's extensive adventure as a software program and database engineer. Written in a calm sort with step by step factors, plenty of screenshots are supplied through the e-book. there are various assistance and priceless tricks all through that aren't present in the unique documentation.
Extra resources for Oracle Applications DBA Field Guide (19)
Sample text
This list may contain unsupported or internally used definitions. The V$NLS_PARAMETERS view shows the current globalization attributes for your session. You can use this view to determine the proper setting for the NLS_LANG environment variable, so that it matches the settings within the database. For example: SELECT * FROM V$NLS_PARAMETERS WHERE parameter='NLS_LANGUAGE' OR parameter='NLS_TERRITORY' OR parameter='NLS_CHARACTERSET'; You use all three values returned by this query to set NLS_LANG.
FF TZR TZD'; 2-11 Copyright © 2004, Oracle. All rights reserved. Configuring Datetime Formats The default date format for the TIMESTAMP WITH TIME ZONE datatype is determined by the value of the NLS_TIMESTAMP_TZ_FORMAT initialization parameter. This parameter can be set at the database level, for a session, or as an environment variable. If you specify the timezone by its name or region, then the Oracle database automatically determines whether daylight savings is in effect for that region and returns local time values based accordingly.
Oracle Database 10g: Administration Workshop II 2-31 Customizing Linguistic Sorting You can customize linguistic sorting for: • Ignorable characters • Contracting or expanding characters • Special combination letters or special letters • Expanding characters or special letters • Special uppercase and lowercase letters • Context-sensitive characters • Reverse secondary sorting • Canonical equivalence 2-32 Copyright © 2004, Oracle. All rights reserved. Customizing Linguistic Sorting Linguistic sorting has many features.