How to find the Oracle Fusion Instance name from Backend using sql

 Table to find out the fusion Instance name: Fusion.ASK_DEPLOYED_DOMAINS

Query:-

SELECT
        external_virtual_host,

        SUBSTR (external_virtual_host, 1,instr(external_virtual_host,'.') -1)
FROM
        fusion.ask_deployed_domains ad
WHERE
        ad.deployed_domain_name='FADomain';