SQL翻成Oracle
select V.SBKTYPE,* from FESBEquityTrade
cross join (select 'EQT ' as SBKTYPE ) as V
where V.SBKTYPE= 'EQT '

//SQL意思是第一加上固定值 'EQT ' as SBKTYPE,然後再作件查
句怎麽改呢?


[解决办法]
select V.SBKTYPE,FESBEquityTrade.* from FESBEquityTrade
cross join (select 'EQT ' as SBKTYPE from dual ) V
where V.SBKTYPE= 'EQT '
[解决办法]
select V.SBKTYPE,* from FESBEquityTrade
cross join (select 'EQT ' as SBKTYPE ) as V
where V.SBKTYPE= 'EQT '

那个 * 前要加上table name即 FESBEquityTrade.*这一点和SQL 是不一样的