Sunday, December 6, 2009

Difference between TIMESTAMP WITH TIMEZONE and TIMESTAMP WITH LOCAL TIMEZONE in oracle 10g:

Difference between TIMESTAMP WITH TIMEZONE and TIMESTAMP WITH LOCAL TIMEZONE in oracle 10g:


The TIMESTAMP WITH TIME ZONE data type data is normalized to the database time zone when it is saved into the database and users see the data in their local session time zone when they select from it.

TIMESTAMP WITH TIME ZONE: The data will not be normalized when data is being saved into database but it has time zone indicator to which refers.

All other DATE, TIMESTAMP data type’s data is normalized to DB time zone when it is saved and data remain unchanged when selected.


NLS_DATE_FORMAT and NLS_TERRITORY parameter values can be used to format the data in desired format.


Difference between Schema and User in oracle

A schema is a collection of database objects, schema is owned by a database user and has same name as that user. By default user has all the access on its own schema objects and other schemas objects based on the grants been granted.
There is 1 to 1 relationship between schema and user.

...

..

No comments:

Post a Comment