17,082
社区成员
发帖
与我相关
我的任务
分享
udcursor :=dbms_sql.open_cursor;
v_sql :="select d.id ,c.startdate,c.enddate from "||sqlstr||" where "||wherestr||" and ((c.startdate>=to_date('2009-1-1','yyyy-mm-dd') and c.ENDDATE<=to_date('2009-12-31','yyyy-mm-dd')) or (c.startdate<=to_date('2009-1-1','yyyy-mm-dd')and c.enddate>=to_date('2009-12-31','yyyy-mm-dd')) or (c.startdate<=to_date('2009-1-1','yyyy-mm-dd') and c.enddate>=to_date('2009-1-1','yyyy-mm-dd') and c.enddate<=to_date('2009-1-1','yyyy-mm-dd')) or (c.startdate>=to_date('2009-1-1','yyyy-mm-dd') and c.startdate<=to_date('2009-12-31','yyyy-mm-dd') and c.enddate>=to_date('2009-12-31','yyyy-mm-dd'))) order by eid";/*这句报错:: identifier 'select d.id ,c.startdate,c.end' too long*/
dbms_sql.parse(udcursor,v_sql,dbms_sql.native);