CURRENT_TRANSFORM_GROUP_FOR_TYPE

Oracle

Example

SELECT CURRENT_TRANSFORM_GROUP_FOR_TYPE('VARCHAR2') AS Current_Transform_Group
FROM dual;

Output

Current_Transform_Group
-----------------------
SYS$XMLTYPE

Explanation

The CURRENT_TRANSFORM_GROUP_FOR_TYPE() function in Oracle returns the name of the current transform group for the specified SQL data type. In this example, we are passing ‘VARCHAR2’ to the function and it returns ‘SYS$XMLTYPE’, which is the current transform group for this type.