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)

Oracle HCM Extracts — A Practical Guide to Building Your First Integration Extract

  HCM Extracts are Oracle's built-in mechanism for extracting structured HR data for payroll interfaces, benefits carriers, and third-pa...

  • Custom Report Notes:
    While Registering the report to instance we need to make sure od date format: 1.The default type is YYYY/MM/DD HH24:MI:SS   go to propert...
  • Order To Cash
    Order to cash normally refer to the process in which taking customer sale order via different sales channel like email, internet, sales pers...
  • Number into word
    This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...