— Oracle Database version along with hostname and instance name
|
1 2 3 4 5 6 |
SELECT instance_name, host_name, version, status, database_status FROM v$instance; |
— Database version along with operating system platform
|
1 |
SELECT name, DB_UNIQUE_NAME, platform_name FROM v$database; |
— Oracle Apps version
|
1 2 3 4 |
SELECT release_name, applications_system_name, aru_release_name FROM FND_PRODUCT_GROUPS; |
— Database Version, PLSQL Version, TNS Version
|
1 |
SELECT * FROM v$version; |
— Oracle workflow version
|
1 |
SELECT text ,name FROM wf_resources WHERE name LIKE ‘%WF_VERSION%’; |
— Oracle XML Publisher / BI Publisher Version
|
1 |
SELECT WF_EVENT_XML.XMLVersion() XML_BI_VERSION FROM dual; |