下面的视图为何在9.03下不起作用,看不懂如何处理?
WITH SPLIT("用户名" ,所属部门,splitstr)
AS
(
SELECT "用户名" ,' ',部门||',' FROM "用户信息视图"
UNION ALL
SELECT "用户名" ,substr(splitstr,0,instr(splitstr,',')),substr(splitstr,instr(splitstr,',')+1)
FROM split WHERE splitstr!=''
)
SELECT "用户名" ,所属部门 FROM split
WHERE 所属部门 !=' '
ORDER BY "用户名"
|