February 21, 2011

Version

To Find out the DB Version Used...

SELECT banner from v$version;  

To find out the Application release used

SELECT product_group_id GroupID, product_group_name GroupName, release_name Release, product_group_type GroupType FROM fnd_product_groups;


at
Labels:

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

Subscribe to: Post Comments (Atom)

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...

  • FND_CANONICAL
    In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ...
  • Interview FAQ's-Oracle Apps Technical and Oracle forms
    Oracle Applications Architecture -           Internet computing Architecture is a framework for 3-tired, distributed computing that ...
  • HRMS API with tables
    Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...