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 是不一样的