SQL语句能直接执行吗?请把具体错误发出来
解决方案 »
- 求助:Oracle SQL Developer 字体 Courier New 中文显示不正常
- 物化视图上面的触发器不起作用
- Oracle 9i简体中文企业版 9i下载地址
- 求助oracle储存过程问题?
- sql语句分类汇总,排序查询语句怎么实现
- 一个难题!这里有人能否帮忙解决?
- 为何我新建的一个数据库打不开啊???
- oracle http server 占用了80端口,但我现在要用iis,怎样才能把80端口解放出来?
- 马上面试要考oracle了,可我对oracle不是很熟,不知道oracle面试会考些什么,多谢!
- Oracle中数据横向集成问题,行转列
- oracle 自动任务 定时执行
- 求SQL语句
select SUBSTR(iufo_measure_pubdata.time_code, 1, 4) as kjnd,
SUBSTR(iufo_measure_pubdata.time_code, 1, 4) ||
SUBSTR(iufo_measure_pubdata.time_code, 9, 2) as kjqj,
case
when (iufo_unit_info.unit_id = '37000011') then
'37000111'
ELSE
iufo_unit_info.unit_id
END unit_id,
iufo_unit_info.unit_name,
iufo_measure_data_duz9rms7.m10001 as hejishouru,
iufo_measure_data_duz9rms7.m10002,
iufo_measure_data_duz9rms7.m10006,
iufo_measure_data_duz9rms7.m10010,
iufo_measure_data_duz9rms7.m10011,
iufo_measure_data_duz9rms7.m10013 as qyqtxjcz,
iufo_measure_data_duz9rms7.m10015,
iufo_measure_data_duz9rms7.m10019,
iufo_measure_data_duz9rms7.m10020,
iufo_measure_data_duz9rms7.m10022,
iufo_measure_data_duz9rms7.m10023,
iufo_measure_data_duz9rms7.m10027,
iufo_measure_data_duz9rms7.m10028,
iufo_measure_data_duz9rms7.m10030,
iufo_measure_data_duz9rms7.m10032,
iufo_measure_data_duz9rms7.m10036,
iufo_measure_data_duz9rms7.m10037,
iufo_measure_data_duz9rms7.m10039,
iufo_measure_data_duz9rms7.m10041,
iufo_measure_data_duz9rms7.m10045,
iufo_measure_data_duz9rms7.m10046,
iufo_measure_data_duz9rms7.m10048,
iufo_measure_data_duz9rms7.m10049,
iufo_measure_data_duz9rms7.m10053,
iufo_measure_data_duz9rms7.m10054,
iufo_measure_data_duz9rms7.m10230,
iufo_measure_data_duz9rms7.m10056,
iufo_measure_data_duz9rms7.m10060,
iufo_measure_data_duz9rms7.m10061,
iufo_measure_data_duz9rms7.m10063,
iufo_measure_data_duz9rms7.m10065,
iufo_measure_data_duz9rms7.m10069,
iufo_measure_data_duz9rms7.m10070,
iufo_measure_data_duz9rms7.m10071,
iufo_measure_data_duz9rms7.m10073,
iufo_measure_data_duz9rms7.m10077,
iufo_measure_data_duz9rms7.m10078,
iufo_measure_data_duz9rms7.m10079,
iufo_measure_data_duz9rms7.m10081,
iufo_measure_data_6urszruw.m10001,
iufo_measure_data_6urszruw.m10013
from iufo_unit_info,
iufo_measure_data_6urszruw,
iufo_measure_pubdata,
iufo_measure_data_duz9rms7
where iufo_measure_data_6urszruw.alone_id = iufo_measure_pubdata.alone_id
and iufo_measure_data_duz9rms7.alone_id = iufo_measure_pubdata.alone_id
and iufo_measure_data_6urszruw.line_no =
iufo_measure_data_duz9rms7.line_no
and iufo_unit_info.unit_id = iufo_measure_pubdata.code
and (iufo_unit_info.level_code like 'i%')
and iufo_measure_pubdata.ver = 0
and iufo_measure_pubdata.formula_id is null;
case when 条件1 then 条件1对应的值 [when 条件2 then 条件2对应的值] [else 缺省值] end
再试更多的代码
接分。
then iufo_unit_info.unit_id='37000111'肯定是不行的。