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

erpprahlad 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

ERP said...

ERPTREE Offering Oracle fusion HCM online training, Oracle Fusion SCM Online Training, Oracle fusion financials online training, Oracle fusion hcm training, Oracle fusion scm training, Oracle fusion financials training, Oracle fusion dba online training in Hyderabad, Bangalore,Gurgon, Noida, India, Dubai, UAE, USA, Kuwait, UK, Singapore, Saudi Arabia, Canada, Delhi, Chennai, Kolkata, Pune, Mumbai, Ahmedabad.


Oracle fusion HCM Online Training

Oracle Fusion HCM Training

Calfre India 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