Skip to content
DBCode

CURRENT_DEFAULT_TRANSFORM_GROUP

Example

Section titled “Example”
SELECT CURRENT_DEFAULT_TRANSFORM_GROUP
FROM dual;

Output

Section titled “Output”
SYS$NULL

Explanation

Section titled “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.