Read or Download Oracle Forms Developer Complete Tutorial [Power Book] PDF
Best databases books
It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can constantly come up over the right meanings of phrases, misunderstandings which can have a major impact at the luck of your database tasks. for instance, listed below are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating staff, sign up for dependency.
Extra info for Oracle Forms Developer Complete Tutorial [Power Book]
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.