SQL查询列中包含()() 执行的时候会报@H_404_2@ORA-00923:未找找到要求的FROM关键字,@H_404_2@
ORACLE会默认列中别名非字母汉字的符号为特殊字符,需用@H_404_2@" "@H_404_2@@H_404_2@@H_404_2@
例子:
SELECT@H_404_2@ to_char(t.gmt_create,@H_404_2@'YYYYMMDD HH24miss'@H_404_2@)@H_404_2@订单时间,@H_404_2@
t.card_name@H_404_2@姓名,@H_404_2@
t.exchange_amount@H_404_2@金额(@H_404_2@分),
t.card_index@H_404_2@卡索引,@H_404_2@
t.core_trans_id@H_404_2@交易核心流水,@H_404_2@
t.order_no@H_404_2@支付核心流水,@H_404_2@
t.status@H_404_2@交易状态,@H_404_2@
t.real_channel_id@H_404_2@渠道ID,@H_404_2@
t.bank_resp_code@H_404_2@银行返回码,@H_404_2@
t.bank_resp_msg@H_404_2@银行返回信息@H_404_2@
@H_404_2@FROM@H_404_2@fxo_withdraw_apply t@H_404_2@
where@H_404_2@t.core_trans_id@H_404_2@in@H_404_2@(@H_404_2@
'O0060005201610260000001287929160'@H_404_2@
)@H_404_2@order@H_404_2@@H_404_2@by@H_404_2@t.core_trans_id;@H_404_2@
SELECT@H_404_2@ to_char(t.gmt_create,@H_404_2@
t.bank_resp_msg@H_404_2@银行返回信息@H_404_2@
@H_404_2@FROM@H_404_2@fxo_withdraw_apply t@H_404_2@
where@H_404_2@t.core_trans_id@H_404_2@in@H_404_2@(@H_404_2@
'O0060005201610260000001287929160'@H_404_2@
)@H_404_2@order@H_404_2@@H_404_2@by@H_404_2@t.core_trans_id;@H_404_2@
SELECT@H_404_2@ to_char(t.gmt_create,@H_404_2@
t.card_name@H_404_2@姓名,@H_404_2@
t.exchange_amount@H_404_2@金额(@H_404_2@分),
t.card_index@H_404_2@卡索引,@H_404_2@
t.core_trans_id@H_404_2@交易核心流水,@H_404_2@
t.order_no@H_404_2@支付核心流水,@H_404_2@
t.status@H_404_2@交易状态,@H_404_2@
t.real_channel_id@H_404_2@渠道ID,@H_404_2@
t.bank_resp_code@H_404_2@银行返回码,@H_404_2@
t.bank_resp_msg@H_404_2@银行返回信息@H_404_2@
@H_404_2@FROM@H_404_2@fxo_withdraw_apply t@H_404_2@
where@H_404_2@t.core_trans_id@H_404_2@in@H_404_2@(@H_404_2@
'O0060005201610260000001287929160'@H_404_2@
)@H_404_2@order@H_404_2@@H_404_2@by@H_404_2@t.core_trans_id;@H_404_2@
@H_404_2@
@H_404_2@
SELECT@H_404_2@ to_char(t.gmt_create,@H_404_2@
t.exchange_amount @H_404_2@"@H_404_2@金额(@H_404_2@分)"@H_404_2@,@H_404_2@
t.card_index@H_404_2@卡索引,@H_404_2@
t.bank_resp_msg@H_404_2@银行返回信息@H_404_2@
@H_404_2@FROM@H_404_2@fxo_withdraw_apply t@H_404_2@
where@H_404_2@t.core_trans_id@H_404_2@in@H_404_2@(@H_404_2@
'O0060005201610260000001287929160'@H_404_2@
)@H_404_2@order@H_404_2@@H_404_2@by@H_404_2@t.core_trans_id;@H_404_2@