Erp100论坛 » Oracle ERP DBA + Oracle Database » Oracle开发 » 邦定变量问题

xiangzhao 发表于 2008-7-11 21:50

邦定变量问题

sql2:='create table temp_mytable1 as select SERV_ID,CALLING_NBR,CALLING_DATE,ticket_id,TICKET_TYPE
from tollcdr_200508_00@db_wlmq
where  rownum<10 and calling_date=:c_date';
execute immediate sql2 using current_date;

xiangzhao 发表于 2008-7-11 21:50

sql2:='create table temp_mytable1 as select SERV_ID,CALLING_NBR,CALLING_DATE,ticket_id,TICKET_TYPE
from tollcdr_200508_00@db_wlmq
where  rownum<10 and calling_date=(to_char(sysdate-1,''yyyymmdd''))';
execute immediate sql2;

查看完整版本: 邦定变量问题