teradata笔记-strtok_split_to_table
1、建表&插数
CREATE TABLE tab (name varchar(5), str varchar(20));
insert into tab VALUES (‘A’,’1234;4568;4567;456');
insert into tab values (‘B’,’5432;;;;’);
insert into tab values (‘C’,’5432,,,,’);
insert into tab values (‘D’,’5432’);
2、分割成表
—备注 tokennum
原创
2021-09-16 16:00:44 ·
779 阅读 ·
0 评论