By Diana Lorentz
Read or Download Oracle 8 SQL Reference PDF
Similar databases books
This ebook brings the entire components of database layout jointly in one quantity, saving the reader the time and rate of creating a number of purchases. It consolidates either introductory and complex themes, thereby masking the gamut of database layout method ? from ER and UML suggestions, to conceptual info modeling and desk transformation, to storing XML and querying relocating gadgets databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an software programming interface (API) that permits purposes written in С or C++ to have interaction with a number of Oracle database servers. OCI provides your courses the aptitude to accomplish the whole 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 educational covers Oracle Warehouse Builder from the floor up, and faucets into the author's large event as a software program and database engineer. Written in a calm kind with step by step reasons, plenty of screenshots are supplied during the publication. there are lots of counsel and precious tricks all through that aren't present in the unique documentation.
Additional resources for Oracle 8 SQL Reference
Example 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.