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/05/16 09:20:41
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
哪里不对啊
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 失败-------------------------------------------------------------
表达式和语句的区别