Oracle与Ms Sqlserver拼结字符串的异同

Ms SqlServer:

 

declare @sql varchar(1000),@temp varchar(10)

set @sql = 'insert into fz (fzgh) values('+'''ddddd'''+')'

exec (@sql);

 

请注意字符串的左右全是单引号。

 

Oracle:

 

strsql  varchar2(200);

 

begin

 strsql :='SELECT K.KSDM KSDM, K.KSMC KSMC, nvl(AA.NEED, 0)  NEED, nvl(BB.NEED, 0) FINISH,
                nvl(BB.NEED*1.0/AA.NEED, 0) AS FINISHPER, nvl(CC.NEED, 0) + nvl(DD.NEED, 0) AS FACT,
                nvl(CC.NEED, 0) AS FIRST, nvl(DD.NEED, 0) AS AGAIN,
                nvl(CC.NEED*1.0/(CC.NEED + nvl(DD.NEED, 0)), 0) AS FIRSTPER,
                nvl(DD.NEED*1.0/(nvl(CC.NEED, 0) + DD.NEED), 0) AS AGAINPER
             FROM GY_KSDM K, HJZX_AA AA, HJZX_BB BB, HJZX_CC CC,HJZX_DD DD WHERE K.KSDM > 400 AND K.BQSY = '||temp||'Y'||temp||' AND
                 K.KSDM=AA.KSDM AND K.KSDM=BB.KSDM AND K.KSDM=CC.KSDM AND K.KSDM=DD.KSDM';

execute immediate(strsql);

end

 

请注意拼接是采用||进行的。