用dbms_sql.parse，动态执行如下语句
create materialized view W_MV_STAT_BILL_TEMP1
REFRESH complete ON DEMAND
START WITH SYSDATE NEXT round(SYSDATE+0.5)+1/16
as
select a.extend1,a.make_date,a.description,nvl(a.extend2,0) as extend2
from w_tbl_log a, W_TBL_STAT_SYS_LOG b
where substr(EXTEND1,6,instr(EXTEND1,'<br>')-6)=b.login;


因为含有'<br>'，总报错请问如何转换？

用'''代替'

用CHR（）

dbms_sql.parse(sql_cursor, 'create materialized view W_MV_STAT_BILL_TEMP1
REFRESH complete ON DEMAND
START WITH SYSDATE NEXT round(SYSDATE+0.5)+1/16
as
select a.extend1,a.make_date,a.description,nvl(a.extend2,0) as extend2
from w_tbl_log a, W_TBL_STAT_SYS_LOG b
where substr(EXTEND1,6,instr(EXTEND1,'''<br>''')-6)=b.login)', dbms_sql.v7);

报如下错误：
PLS-00103: 出现符号 ">"在需要下列之一时：   . ( ) , * @ % & - + / at mod     remainder rem <an exponent (**)> and or || multiset

那'<','>' 用chr(60)和chr(62)代替掉

dbms_sql.parse(sql_cursor, 'create materialized view W_MV_STAT_BILL_TEMP1
REFRESH complete ON DEMAND
START WITH SYSDATE NEXT round(SYSDATE+0.5)+1/16
as
select a.extend1,a.make_date,a.description,nvl(a.extend2,0) as extend2
from w_tbl_log a, W_TBL_STAT_SYS_LOG b
where substr(EXTEND1,6,instr(EXTEND1,chr(60)||'br'||chr(62))-6)=b.login;
还是报如下错误：
PLS-00103: 出现符号 "BR"在需要下列之一时：   ) , * & | = - + < / > at in     is mod remainder not rem => .. <an exponent (**)>     <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_     between || multiset member SUBMULTISET_

try this：substr(EXTEND1,6,instr(EXTEND1,chr(39)||chr(60)||br||chr(62)||chr(39))-6)=

dbms_sql.parse(sql_cursor, 'create materialized view W_MV_STAT_BILL_TEMP1
REFRESH complete ON DEMAND
START WITH SYSDATE NEXT round(SYSDATE+0.5)+1/16
as
select a.extend1,a.make_date,a.description,nvl(a.extend2,0) as extend2
from w_tbl_log a, W_TBL_STAT_SYS_LOG b
where substr(EXTEND1,6,instr(EXTEND1,chr(39)||chr(60)||br||chr(62)||chr(39))-6)=b.login', dbms_sql.v7);
还是报错。

顶

报什么错，最好先把动态语句赋值给一变量，把错误贴出来