Oracle CON_NAME_TO_ID() Function

Oracle CON_NAME_TO_ID() is a built-in function that returns the container ID based on the container name.

Oracle `CON_NAME_TO_ID()` Syntax

Here is the syntax for the Oracle CON_NAME_TO_ID() function:

CON_NAME_TO_ID(container_name)

container_name: Required. The container name. It can be a string or any type that can be resolved to a string.

The Oracle CON_NAME_TO_ID() function returns the container ID, which is a NUMBER value.

If any of the parameters is NULL, CON_NAME_TO_ID() returns NULL.

Here are a few examples that demonstrate the usage of the Oracle CON_NAME_TO_ID() function.

You can query all container names and container IDs from the V$CONTAINERS view, as shown in the following statement:

SELECT
    CON_ID, NAME
FROM v$containers;

Output:

   CON_ID NAME
_________ ___________
        1 CDB$ROOT
        2 PDB$SEED
        3 XEPDB1

If you need to get the container ID for the container name XEPDB1, use the CON_NAME_TO_ID() function:

SELECT
    CON_NAME_TO_ID('XEPDB1')
FROM dual;

Output:

   CON_NAME_TO_ID('XEPDB1')
___________________________
                          3

If any of the parameters is NULL, CON_NAME_TO_ID() returns NULL.

SET NULL 'NULL';
SELECT
    CON_NAME_TO_ID(NULL)
FROM dual;

Output:

   CON_NAME_TO_ID(NULL)
_______________________
                   NULL

In this example, we use the statement SET NULL 'NULL'; to display the NULL value as the string 'NULL'.

Oracle CON_NAME_TO_ID() is a built-in function that returns the container ID based on the container name.