oracle 语句 缺失表达式错误create or replace view vw_bus_specialtyassessment3 asselectt.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore),from bus_specialtyassessitem t1,bus_specialtyassessment twhere t1.speci

来源：学生作业帮助网 编辑：作业帮 时间：2024/04/27 20:07:59

oracle 语句 缺失表达式错误create or replace view vw_bus_specialtyassessment3 asselectt.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore),from bus_specialtyassessitem t1,bus_specialtyassessment twhere t1.speci
oracle 语句 缺失表达式错误
create or replace view vw_bus_specialtyassessment3 as
select
t.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore),
from bus_specialtyassessitem t1,bus_specialtyassessment t
where
t1.specialtyassessitemid=1
order by t.year
哪里不对啊

oracle 语句 缺失表达式错误create or replace view vw_bus_specialtyassessment3 asselectt.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore),from bus_specialtyassessitem t1,bus_specialtyassessment twhere t1.speci
create or replace view vw_bus_specialtyassessment3 as
select
t.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore)
from bus_specialtyassessitem t1,bus_specialtyassessment t
where
t1.specialtyassessitemid=1
group by t.year ,t.month ,t.assessdeptid ,t1.objectid order by t.year

oracle 语句 缺失表达式错误create or replace view vw_bus_specialtyassessment3 asselectt.year ,t.month ,t.assessdeptid ,t1.objectid ,count(t1.objectid),sum(t1.chargescore),from bus_specialtyassessitem t1,bus_specialtyassessment twhere t1.speci oracle语句报缺失表达式,貌似是decode用法不对?where t1.high_company_id =decode(c1.company_level,'4',select high_company_id from fnd_company_level where company_id= c1.company_id ,c1.company_id ) oracle报错00936 缺失表达式 错误 select t.comcode 组代码,(select y.comcname from cc_company y where y.comcode=t.comcode) 组名称,sum(decode(aa.a3,0,aa.a1,0)) as 零分总量,sum(decode(aa.a3,1,aa.a1,0)) as 一分总量,sum(decode(aa.a3,2 Oracle 11g 安装错误 Oracle Configuration Manager Configuration失败 Oracle错误 ORA-12560如何解决 oracle sql 语句中where条件中 1=1 oracle 语句 where t1.row_id=t2.row_id(+) if语句条件表达式 CRE是什么? Oracle-12514错误发生的几种原因 ae的表达式错误 ae表达式错误 oracle 语句取时间（times）字段 大于等于当前系统时间的语句怎么写 怎样区分表达式和表达式语句? 一下语句哪里错误 改正语句中的错误 安装出现 Oracle Database Configuration Assistant 失败的错误服务中只出现OracleOraDb10g_home1TNSListerConfiguration Assistant Oracle Database Configuration Assistant 失败------------------------------------------------------------- 表达式和语句的区别