Unpack (
[ ON { table | view | (query) } AS InputTable ]
USING
TargetColumn ('target_column')
OutputColumns ('output_column' [,...])
OutputDataTypes ('datatype' [,...])
[ Delimiter ('delimiter') ]
[ ColumnLength ('column_length' [,...] ) ]
[ Regex ('regular_expression') ]
[ RegexSet ('group_number') ]
[ IgnoreInvalid ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
[ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ]
)
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement