关于oracle 存储过程 调用动态sql

--开始时间拼接\' 00:00:00\'
  V_SQL := \'select decode(length(\' || V_END || \'),10,\' || \'concat(\' || V_END || \', 00:00:00),\' || V_END || \') from dual\';
  EXECUTE IMMEDIATE V_SQL;

V_SQL := \'select decode(length(:v1),10,:v2,:v3) from dual\';
EXECUTE IMMEDIATE V_SQL INTO V_START USING V_START,V_START || \' 00:00:00\',V_START;

--结束时间拼接\' 00:00:00\'
SELECT DECODE(LENGTH(V_END), 10, V_END || \' 00:00:00\', V_END) INTO V_END FROM DUAL;

  --业务执行
  OPEN OUT_CURSOR FOR \'SELECT TO_CHAR(TO_DATE(\' || STARTTIME || \', \'\'YYYY-MM-DD\'\') + ROWNUM - 1,
                            \'\'YYYY-MM-DD\'\') AS REGDATE
               FROM DUAL
             CONNECT BY ROWNUM <=
                        TRUNC(TO_DATE(\' || ENDTIME || \', \'\'YYYY-MM-DD\'\') -
                              TO_DATE(\' || STARTTIME || \', \'\'YYYY-MM-DD\'\')) + 1\';