PL/SQL里的语法问题

[奇零草]

create or replace view v_ca_variation_crworktask as
select TC.DSGC_CR_UUID, case TC.CR_STATUS
when '1' then TDW.CURRENT_TACHE
when '2' then '关闭'
when '3' then '取消'
end as spare1
from IMS.DSGC_CR TC
left join IMS.IMSWF_DAILYWRK TDW on TC.DSGC_CR_UUID = TDW.BUSS_UUID
ORDER BY TC.DSGC_CR_UUID DESC
中“end as spare1”里面的as是什么意思？
spare1是IMS.IMSWF_DAILYWRK里的一个字段。

[chd2001]

case TC.CR_STATUS
when '1' then TDW.CURRENT_TACHE
when '2' then '关闭'
when '3' then '取消'
end
as spare1
end是对case而言的标准格式:case when then end

as spare1是给这个值的一个名
相当于 select f1 as 字段1 from tab

[hongqi162]

字段别名

[奇零草]

我记得字段别名应该不用加as呀，直接一个空格就行了呀

[hyrongg]

别名：

SQL> select sysdate as "我靠" from dual;

我靠
-----------
12/04/2007

SQL>

[hyrongg]

SQL> select sysdate "我靠" from dual;

我靠
-----------
12/04/2007

[奇零草]

是的，谢谢！