insert into service_531 (servicecode,servicename,modulename, clientid,pricetime,pricenew,policy,dealaccount,dealtime)
select code,name,typeid,tempclientid,to_date(createdtime,'yyyy-mm-dd hh24:mi:ss'),to_number(price),policy,tempaccount,sysdate 
from business

解决方案 »

  1.   

    过程或函数的例子:
    create or replace procedure test as
        tempclientid varchar2(10):='1x';
        tempaccount  varchar2(10):='6002';
    begin
        insert into table    ....    select ......;
    end;
      

  2.   

    帮忙看下为何提示有编译错误??
    其中下面的select子句单独执行无问题(不带变量)create or replace procedure proc_busi2serv as
        tempclientid varchar2(10):='1x';
        tempaccount  varchar2(10):='6002';
    begin
    insert into service_531 (servicecode,servicename,modulename, clientid,pricetime,pricenew,policy,dealaccount,dealtime)
    select "code","name","typeid",tempclientid,to_date("createdtime",'yyyy-mm-dd hh24:mi:ss'),to_number("price"),"policy",tempaccount,sysdate 
    from business;
    end;
      

  3.   

    select "code","name","typeid",tempclientid,to_date("createdtime",'yyyy-mm-dd hh24:mi:ss'),to_number("price"),"policy",tempaccount,sysdate "code",>>>>'code'