为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:V8
【操作系统】:W11
【CPU】:
【问题描述】*:创建视图后,查询视图报错(视图中查询语句,单独查询没有问题)
错误号:[-2007]
错误消息:第2 行附近出现错误: 语法分析出错
语句如下:
CREATE VIEW "GCTEST"."V_TASK"
AS
SELECT
"T"."ID" AS "BUSINESS_ID",
"P"."ID" AS "PROJECT_ID",
"P"."PROJECT_NAME" AS "PROJECT_NAME",
'领导督办-处理' AS "TASK_NAME",
'01' AS "TASK_TYPE",
'项目责任单位填报处理意见' AS "TASK_CONTENT",
"T"."START_TIME" AS "TASK_TIME",
"USER"."NICK_NAME" AS "TASK_HANDLER_NAME",
"USER"."USER_ID" AS "TASK_HANDLER_ID"
FROM
(SELECT "TB_SUPERVISION_FLOW"."ID" AS "ID","TB_SUPERVISION_FLOW"."START_TIME" AS "START_TIME","TB_SUPERVISION_FLOW"."SUPERVISION_ID" AS "SUPERVISION_ID"
FROM "TB_SUPERVISION_FLOW"
WHERE ("TB_SUPERVISION_FLOW"."SUPERVISION_LINK" = '02' AND "TB_SUPERVISION_FLOW"."STATUS" = 1)) "T"
JOIN "TB_SUPERVISION" "S" ON ("T"."SUPERVISION_ID" = "S"."ID" AND "S"."SUPERVISION_STATUS" = 1)
JOIN "TB_PROJECT" "P" ON ("S"."PROJECT_ID" = "P"."ID")
JOIN (SELECT "U"."USER_ID" AS "USER_ID","U"."DEPT_ID" AS "DEPT_ID","U"."USER_NAME" AS "USER_NAME","U"."NICK_NAME" AS "NICK_NAME","U"."USER_TYPE" AS "USER_TYPE","U"."EMAIL" AS "EMAIL","U"."PHONENUMBER" AS "PHONENUMBER","U"."SEX" AS "SEX","U"."AVATAR" AS "AVATAR","U"."PASSWORD" AS "PASSWORD","U"."STATUS" AS "STATUS","U"."DEL_FLAG" AS "DEL_FLAG","U"."LOGIN_IP" AS "LOGIN_IP","U"."LOGIN_DATE" AS "LOGIN_DATE","U"."CREATE_BY" AS "CREATE_BY","U"."CREATE_TIME" AS "CREATE_TIME","U"."UPDATE_BY" AS "UPDATE_BY","U"."UPDATE_TIME" AS "UPDATE_TIME","U"."REMARK" AS "REMARK","U"."IS_DEPARTMENT_HEAD" AS "IS_DEPARTMENT_HEAD"
FROM "SYS_USER" "U"
WHERE "U"."USER_ID" IN (SELECT "UR"."USER_ID"
FROM "SYS_USER_ROLE" "UR"
JOIN "SYS_ROLE" "R" ON "UR"."ROLE_ID" = "R"."ROLE_ID"
WHERE "R"."ROLE_KEY" = 'common')) "USER" ON ("USER"."DEPT_ID" = "P"."RESPONSIBLE_DEPARTMENT")
UNION ALL
SELECT
"T"."ID" AS "BUSINESS_ID",
"P"."ID" AS "PROJECT_ID",
"P"."PROJECT_NAME" AS "PROJECT_NAME",
'领导督办-核定' AS "TASK_NAME",
'01' AS "TASK_TYPE",
'发改局核定责任单位上报的处理意见' AS "TASK_CONTENT",
"T"."START_TIME" AS "TASK_TIME",
"USER"."NICK_NAME" AS "TASK_HANDLER_NAME",
"USER"."USER_ID" AS "TASK_HANDLER_ID"
FROM
(SELECT "TB_SUPERVISION_FLOW"."ID" AS "ID","TB_SUPERVISION_FLOW"."START_TIME" AS "START_TIME","TB_SUPERVISION_FLOW"."SUPERVISION_ID" AS "SUPERVISION_ID"
FROM "TB_SUPERVISION_FLOW"
WHERE ("TB_SUPERVISION_FLOW"."SUPERVISION_LINK" = '03' AND "TB_SUPERVISION_FLOW"."STATUS" = 1)) "T"
JOIN "TB_SUPERVISION" "S" ON ("T"."SUPERVISION_ID" = "S"."ID" AND "S"."SUPERVISION_STATUS" = 1)
JOIN "TB_PROJECT" "P" ON ("S"."PROJECT_ID" = "P"."ID")
JOIN (SELECT "U"."USER_ID" AS "USER_ID","U"."DEPT_ID" AS "DEPT_ID","U"."USER_NAME" AS "USER_NAME","U"."NICK_NAME" AS "NICK_NAME","U"."USER_TYPE" AS "USER_TYPE","U"."EMAIL" AS "EMAIL","U"."PHONENUMBER" AS "PHONENUMBER","U"."SEX" AS "SEX","U"."AVATAR" AS "AVATAR","U"."PASSWORD" AS "PASSWORD","U"."STATUS" AS "STATUS","U"."DEL_FLAG" AS "DEL_FLAG","U"."LOGIN_IP" AS "LOGIN_IP","U"."LOGIN_DATE" AS "LOGIN_DATE","U"."CREATE_BY" AS "CREATE_BY","U"."CREATE_TIME" AS "CREATE_TIME","U"."UPDATE_BY" AS "UPDATE_BY","U"."UPDATE_TIME" AS "UPDATE_TIME","U"."REMARK" AS "REMARK","U"."IS_DEPARTMENT_HEAD" AS "IS_DEPARTMENT_HEAD","R"."ROLE_KEY" AS "ROLE_KEY"
FROM "SYS_USER" "U"
JOIN "SYS_USER_ROLE" "UR" ON "U"."USER_ID" = "UR"."USER_ID"
JOIN "SYS_ROLE" "R" ON "UR"."ROLE_ID" = "R"."ROLE_ID") "USER" ON ("USER"."ROLE_KEY" = 'DR')
UNION ALL
SELECT
"T"."ID" AS "BUSINESS_ID",
"P"."ID" AS "PROJECT_ID",
"P"."PROJECT_NAME" AS "PROJECT_NAME",
'领导督办-确认' AS "TASK_NAME",
'01' AS "TASK_TYPE",
'县领导确认督办问题是否已经解决' AS "TASK_CONTENT",
"T"."START_TIME" AS "TASK_TIME",
"USER"."NICK_NAME" AS "TASK_HANDLER_NAME",
"USER"."USER_ID" AS "TASK_HANDLER_ID"
FROM
(SELECT "TB_SUPERVISION_FLOW"."ID" AS "ID","TB_SUPERVISION_FLOW"."START_TIME" AS "START_TIME","TB_SUPERVISION_FLOW"."SUPERVISION_ID" AS "SUPERVISION_ID"
FROM "TB_SUPERVISION_FLOW"
WHERE ("TB_SUPERVISION_FLOW"."SUPERVISION_LINK" = '04' AND "TB_SUPERVISION_FLOW"."STATUS" = 1)) "T"
JOIN "TB_SUPERVISION" "S" ON ("T"."SUPERVISION_ID" = "S"."ID" AND "S"."SUPERVISION_STATUS" = 1)
JOIN "TB_PROJECT" "P" ON ("S"."PROJECT_ID" = "P"."ID")
JOIN "SYS_USER" "USER" ON ("USER"."USER_ID" = "S"."SUPERVISION_USER_ID") ;
你是哪个数据库版本,SELECT '版本号',(SELECT id_code)FROM v$instance;
创建简单的视图能成功吗?CREATE or replace VIEW "V_TASK"
AS select PARA_NAME,PARA_VALUE,'领导督办-处理' AS "TASK_NAME" from v$dm_ini where para_name like 'A%'
union ALL
select PARA_NAME,PARA_VALUE,'发改局核定责任单位上报的处理意见' AS "TASK_NAME" from v$dm_ini where para_name like 'C%'