as 后面表示别名,这一列的字段名已改
select decode (t_a,1,'你好') as a from table
t_a列查询结果为1时,则显示你好,并且字段t_a也已经修改为a
--------------
where trim(a.order)=b.name(+)
+在左边是右连接, +在右边是左连接
as 后面表示别名,这一列的字段名已改
select decode (t_a,1,'你好') as a from table
t_a列查询结果为1时,则显示你好,并且字段t_a也已经修改为a
--------------
where trim(a.order)=b.name(+)
+在左边是右连接, +在右边是左连接