ANYDATA
Last updated
Last updated
This type contains an instance of a given type, with data, plus a description of the type.
ANYDATA
can be used as a table column data type and lets you store heterogeneous values in a single column. The values can be of SQL built-in types as well as user-defined types. ().
The ANYDATA
data type is not supported in Snowflake.
This example is not a translation of SnowConvert, it is only used to show the functional equivalence between Oracle ANYDATA
and Snowflake VARIANT
We are using the ANYDATA
built-in package. The conversion for this package is currently not supported by SnowConvert.
Most operations with ANYDATA
columns require to use the ANYDATA
built-in package, transformation for Oracle built-in packages is not supported by SnowConvert yet.
: Number type column may not behave similarly in Snowflake.
: Pending Functional Equivalence Review.