My Oracle Support Banner

How To Determine The Environment In A Script (e.g. an APEX Applicatoin or ORDS Serivce) (Doc ID 2980296.1)

Last updated on OCTOBER 13, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.


Goal: Use a single script that will work in all Environments, using an identifier to determine the Environment.

The cloud_identity field FROM v$pdbs is unique in each Environment. Does the database_name in this field ever change? Can it be used to reliably identify the Environment?

If not, what would the best way be to identify the Environment via a script?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.