Friday, January 7, 2022

How to find Oracle Fusion Instance Name through SQL

Wondering how to find the name of your Fusion instance ? Here's the query that will retrieve this information -


SELECT
    SUBSTR(
        EXTERNAL_VIRTUAL_HOST,
        1,
        INSTR(EXTERNAL_VIRTUAL_HOST, '.') -1
    ),
    DEPLOYED_DOMAIN_NAME
FROM
    FUSION.ASK_DEPLOYED_DOMAINS

Share: