select w2_month as x,w2_week as y,x-y as z from table例子:这里我用了x y 2个别名分别表示2个字段(number类型) 现在我想用别名进行相减 这种好像不可以,请问有什么办法可以解决吗?
实际需求:W2实际入库周 是更加一个select 语句获取的 --case when(W2实际入库周 - W2计划入库周) > 0 then '10'
-- when(W2实际入库周- W2计划入库周) = 0 then '20'
-- when(W2实际入库周 -W2计划入库周) < 0 then '30'
--end as 'W2是否按期入库类型',
实际需求:W2实际入库周 是更加一个select 语句获取的 --case when(W2实际入库周 - W2计划入库周) > 0 then '10'
-- when(W2实际入库周- W2计划入库周) = 0 then '20'
-- when(W2实际入库周 -W2计划入库周) < 0 then '30'
--end as 'W2是否按期入库类型',
解决方案 »
- Oracle存储过程游标不能下移?为什么?
- 俩个字段都不重复的行数,怎么查??
- [Oracle 11g]Win 7 安装时 使用DBCA创建配置数据库时报错
- 存储过程和过程有什么区别啊!
- 关于oracle移植的问题
- CrystalReport的数据导出有什么注意事项么?点击报表的导出按钮,没有反应
- 一个简单的sql文问题
- 急!在线,连不到数据库,报错ORA-12560:TNS 协议适配器错误,怎么办?
- Oracle 权限管理问题
- weblogic 启用管理端口9002 报错 bea-090476
- oracle导出方案时内存不足
- Oracle文档里这样的图表符号是什么意思,在那个官方Oracle文档里有介绍这样图表的?
这个会被当做单独列来处理不知道这样子和需求相符合吗?hr@ORCL> create table t1 (id1 number,id2 number);Table created.hr@ORCL> insert into t1 values(1,2);1 row created.hr@ORCL> commit;Commit complete.hr@ORCL> with a as (select id1 x,id2 y,id1-id2 as z from t1)
2 select x,y,z from a; X Y Z
---------- ---------- ----------
1 2 -1
select w2_configure_id.nextval,'' as 统计汇总ID,C.Ordtype as 单据统计类型, D.cartypesn 车型代码,C.Dlrorderid as 采购单主单ID,B.Subdlrorderid as 采购单子单ID,
C.planinweek as W2计划入库周,
(select (w2_year||lpad(w2_month,2,0)||lpad(w2_week,2,0) )
from w2_configure
where A.Indate between w2_configure.w2_week_startday and w2_configure.w2_week_endday
and rownum = 1) as W2实际入库周,A.Indate as W2实际入库时间,
--case when(W2实际入库周 - W2计划入库周) > 0 then '10'
-- when(W2实际入库周- W2计划入库周) = 0 then '20'
-- when(W2实际入库周 -W2计划入库周) < 0 then '30'
--end as 'W2是否按期入库类型',
10,
10000,
sysdate as 操作时间,
A.Houseinid as 入库单ID
from t_vopr_housein_m A, t_vopr_dlrorder_d B, t_vopr_dlrorder_m C, t_vcar_car_m D
where A.Src_Billid = B.Subdlrorderid and B.Dlrorderid = C.Dlrorderid and B.CARID = D.CARID
W2实际入库周:
select (w2_year||lpad(w2_month,2,0)||lpad(w2_week,2,0) ) from w2_configure where A.Indate between w2_configure.w2_week_startday and w2_configure.w2_week_endday and rownum = 1) as
select (select a from table) as a,b,a-b as c from table1上面这种形式的 不行 不能用 a-b as c 别名不能这样用!!!
请问有什么办法 演变下处理!!!
(select w2_month x ,w2_week y from table)