Thursday, December 17, 2009

Oracle SQL Learnings

  • NLS settings

    NLS settings supports the globalization of the db instance. It has variety of parameters like NLS_LANGUAGE, NLS_TERRITORY etc. The settings can be done at three level database, instance and session level. Session level takes precedance over the other two. The NLS settings are stored in
    NLS_DATABASE_PARAMETERS,
    NLS_INSTANCE_PARAMETERS,
    NLS_SESSION_PARAMETERS.

    The session can be set as
    ALTER SESSION SET parameter_name = 'parameter_value'
    Example:
    ALTER SESSION SET NLS_TERRITORU = 'AMERICA'.

    NLS settings governs lots of db settings like date, time format, calendar, start of week, etc

  • LOCK TABLE

    An update of any table can be prevented by putting lock on it using below command.

    LOCK TABLE hr.per_medical_assessments IN EXCLUSIVE MODE;

    The lock is removed by either a coomit or a rollback


  • CALUCLATING AGE

    Age can be calculated as
    FLOOR ( MONTHS_BETWEEN(trunc(sysdate) , ppx.DATE_OF_BIRTH)/12) age

6 comments:

oraclefusion said...

Thanks for sharing the useful information for ore visit
Oracle Fusion

oraclefusion said...

Thanks for sharing and for more information visit
Oracle Fusion

ORACLE FUSION PROCUREMENT said...

Thanks for sharing informative post. you have given more information post.
in that we are taking some issues for that.

ORACLE FUSION PROCUREMENT said...

Thanks for sharing informative post.it is very valuable post.
oracle fusion SCM on line training

Unknown said...

very interesting article i feel very enthusiastic while reading and the information
provided in this article is so useful for me.content in this article guides in clarifying some of my doubts of oracle fusion financials


Oracle fusion Financials Training in hyderabad

Oracle Fusion Financials online Training in hyderabad

fusionscmtraininginhyderabad said...

Moreover, the keyword serves as a guiding beacon for individuals actively seeking online training resources specific to Oracle Fusion HCM Online Training. It indicates that while the blog provides valuable SQL learnings, there is a broader educational landscape available for those aspiring to achieve proficiency in Oracle's advanced Human Capital Management through specialized online training.