Is there a way to find the actual name of the current IFS instance/database from a SQL query, for use somewhere like a custom field or report?

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

Yes — SELECT Sys_Context('UserEnv', 'Db_Name') AS Instance FROM Dual returns the current database's name using Oracle's own session-context function, which reflects the actual instance/database you're connected to.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions