Wednesday, August 10, 2011

Oracle Apps - Quick How Tos


Q) How to find the Oracle Apps instance version ?
Ans - select RELEASE_NAME from fnd_product_groups

Q) How to find the Oracle Apps Database version ?
Ans - select version from v$instance

Q) How to find the hostname of an oracle apps instance ?
Ans - select host_name from v$instance

Q) How to find the instance name of an oracle apps instance ?
Ans - select instance_name from v$instance
Posted by Deep at 11:40 PM
Labels: , , , , , ,

2 comments:

  1. AnonymousAugust 30, 2011

    hi
    thank u for providing some questionaire...its quite informative...

    oracle fussion middleware

    ReplyDelete
  2. Oracle Apps TipsSeptember 06, 2011

    Thanks! plz keep watching this space.

    ReplyDelete

Subscribe to: Post Comments (Atom)