Tuesday, September 11, 2007

Why Does My Deodorant Burn?

Tuning ORACLE - Date Functions: TO_DATE

The to_date function converts a string to date.

The syntax is:

to_date (string1, [format_mask], [nls_language])

string1 is the string that will be converted to date.

format_mask is optional. this is the format will be used to convert string to date.

nls_language is optional. It is the language used to convert from string to DATEE.


Possible paraemtros used as format_mask.

Parameter Explanation
YEAR Year, spell out
YYYY 4-digit year


YYY YY Y Last
3, 2, or 1 digit (s) of year.
IYY
IY
I
Last 3, 2, or 1 digit(s) of ISO year.
IYYY 4-digit year based on the ISO standard
RRRR Accepts a 2-digit year and returns a 4-digit year.
A value between 0-49 will return a 20xx year.
A value between 50-99 will return a 19xx year.
Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1).
MM Month (01-12; JAN = 01).
MON Abbreviated name of month.
MONTH Name of month, padded with blanks to length of 9 characters.
RM Roman numeral month (I-XII; JAN = I).
WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.
W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.
IW Week of year (1-52 or 1-53) based on the ISO standard.
D Day of week (1-7).
DAY Name of day.
DD Day of month (1-31).
DDD Day of year (1-366).
DY Abbreviated name of day.
J Julian day; the number of days since January 1, 4712 BC.
HH Hour of day (1-12).
HH12 Hour of day (1-12).
HH24 Hour of day (0-23).
MI Minute (0-59).
SS Second (0-59).
SSSSS Seconds past midnight (0-86399).
FF Fractional seconds. Use a value from 1 to 9 after FF to indicate the number of digits in the fractional seconds. For example, 'FF4'.
AM, A.M., PM, or P.M. Meridian indicator
AD or A.D AD indicator
BC or B.C. BC indicator
TZD Daylight savings information. For example, 'PST'
TZH Time zone hour.
TZM Time zone minute.
TZR Time zone region.

Ejemplos:

to_date('2008/07/09', 'yyyy/mm/dd') would return a date value of July 9, 2008.
to_date('070908', 'MMDDYY') would return a date value of July 9, 2008.
to_date ('20080315 ',' yyyymmdd ') Would return a date value of Mar 15, 2008.
More

Oracle Oracle

Tuesday, July 17, 2007

Is Mouth Cancer Affect From One Person To Another

ORACLE - DBA: Roles and Responsibilities

Oracle DBA: Roles and Responsibilities

The DBA or system administrator of the BD a company is always regarded as the most experienced person in the area of \u200b\u200bdatabases. Therefore, it should be clear about the expectations generated around their work and what are the main roles to be resolved within the corporate framework or project.

Basic Tasks :

Ensure system security

The DBA should always monitor and manage system security. This involves adding and removing users, managing disk space (quota), audits and periodic review to identify likely problems of security.

risk prevention

Another task of the DBA is to schedule maintenance on the database (logical files) or to cooperate in maintaining machine system administrator. The DBA should strengthen its efforts in order to eliminate problems or hazardous situations.


Installing new software components

One of the main tasks of the DBA is the periodic installation of new Oracle software updates, both in terms of application programs as management tools . It is also recommended that the DBA own and other users of Oracle installation and test new configurations before migrating to production environments.

Interaction Manager

system In most cases the programs can only be installed or accessed by the system administrator. In this case, the DBA should always work very well coordinated with him to ensure that both the installation and configuration of software and hardware provides adequate performance database engine and application. Monitoring


The DBA must continually monitor system performance and be prepared to make adjustments to tuning it. On occasion this involves changing only a few parameters and sometimes rebuild or restructure rates tables. Backups


Because the most important task of DBA is to protect the integrity of the data, we must develop an effective strategy for data backup and recovery to maintain the stability of the stored information. The frequency of these backups should be decided depending on the number of processes that alter the data over time.

Additional Tasks

Other important tasks under often made to a DBA are:

  • support the design and optimization data models.
  • Analyze data and make recommendations regarding improving the performance and efficiency in handling data that are stored.
  • Assist developers with knowledge of SQL and construction stored procedures and triggers , among others.
  • Document and keep records of periodic maintenance, hardware and software upgrades, application changes and, in general, all events related to changes in the use of a database.
  • Support the definition of design standards and classification of objects.

More Oracle
Mas Oracle