当字段内有逗号分隔时,Oracle如何对这些字段值进行分组
发布时间:2020-12-12 14:58:12 所属栏目:百科 来源:网络整理
导读:CREATE TABLE info( users varchar (100) ); INSERT INTO info VALUES ( 'userA@userB@userC' ); 'userB@userC@userD' ); 'userC@userD@userE' ); COLUMN "用户" FORMATA15 SELECT to_char(strvalue) as , count (*) AS "用户数" FROM info, table (fn_split