首页 > 代码库 > oracle 常用语句

oracle 常用语句

1.cast

CAST(‘Other‘ as NVARCHAR2(30))

 

2.for

declare  v_guid char(32); channelidStrs  varchar2(4000):=‘‘;begin    v_guid:=sys_guid();    --delete temp_stocktransdetail;    for c in (select channelid from channel where rownum<9) loop      channelidStrs :=channelidStrs||,|| c.channelid;    end loop;     DBMS_OUTPUT.PUT_LINE(channelidStrs);    DBMS_OUTPUT.PUT_LINE(v_guid);    pro_getcalcdaystock(v_guid,332359248d04da0c7e997f82d0e369ca,‘‘,2014-08-30);    commit;end;

 

oracle 常用语句