CON_UID_TO_ID
takes as its argument a container UID (unique identifier) and returns the container ID. For container_uid
, specify a NUMBER
value or any value that can be implicitly converted to NUMBER
. The function returns a NUMBER
value.
This function is useful in a multitenant container database (CDB). If you use this function in a non-CDB, then it returns 0.
The following query displays the ID and UID for all containers in a CDB. The sample output shown is for the purpose of this example.
SELECT CON_ID, CON_UID FROM V$CONTAINERS; CON_ID CON_UID ---------- ---------- 1 1 2 4054529501 4 2256797992
The following query returns the ID for the container with UID 2256797992:
SELECT CON_UID_TO_ID(2256797992) "Container ID" FROM DUAL; Container ID ------------ 4