关于ORACLE查询列加()or () 报ORA-00923:未找找到要求的FROM关键字

前端之家收集整理的这篇文章主要介绍了关于ORACLE查询列加()or () 报ORA-00923:未找找到要求的FROM关键字前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

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@

解决方法:@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@

猜你在找的Oracle相关文章