CURRENT_DEFAULT_TRANSFORM_GROUP

CURRENT_DEFAULT_TRANSFORM_GROUP is a built-in SQL function utilized to return the name of the default transformation group for the current session. It is typically used in scenarios that involve manipulation and transformation of LOB data in Oracle database.

Example

SELECT CURRENT_DEFAULT_TRANSFORM_GROUP
FROM dual;

Output

SYS$NULL

Explanation

The CURRENT_DEFAULT_TRANSFORM_GROUP function returns the current value of the DEFAULT_TRANSFORM_GROUP initialization parameter. This parameter specifies a SQL*Loader control file-embedded SQL statement’s default SQL transform group if no specific SQL transform group is specified. Here, it is returning SYS$NULL indicating no specific transform group is currently set.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.