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)
Parameters
container_name
-
Required. The container name. It can be a string or any type that can be resolved to a string.
Return Value
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
.
Oracle CON_NAME_TO_ID()
Examples
Here are a few examples that demonstrate the usage of the Oracle CON_NAME_TO_ID()
function.
Basic Usage
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
NULL Parameter
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'
.
Conclusion
Oracle CON_NAME_TO_ID()
is a built-in function that returns the container ID based on the container name.