是我太久没用oracle了吗,列别名用 “ ”
sql如下,简单单表查询
--盘库表
select notice_target as '通知对象选择',attentiontext as '注意事项'
from T_PANKU where uq_apply_code = '220200528521765C000004'
竟然报错了
百度一番,原因是列别名用 “ ”
改后:
select notice_target as "通知对象选择",attentiontext as "注意事项"
from T_PANKU where uq_apply_code = '220200528521765C000004'
OK了