CREATE OR REPLACE PROCEDURE P_PROD_UV(P_STARTTIME IN VARCHAR ,P_ENDTIME IN VARCHAR) IS
/*-----------------------------------------------------------+
|程序目的:提取各月各产品的用户数(UV,平均访问天数)
+------------------------------------------------------------*/
/* CREATE TABLE T_PROD_UV
(
SDATE DATE,PROD_CNNAME VARCHAR2(50),
UV NUMBER,AVGVISITDAY NUMBER(4,2)
);
CREATE TABLE T_PLOG
(P_NAME VARCHAR(40),ID INT,INSERTDATE DATE,FALG VARCHAR(10));
*/
--SET SERVEROUTPUT ON ;
STARTTIME DATE;
ENDTIME DATE;
V_SDATE DATE;
V_NUM NUMBER;
V_SQL_MEG VARCHAR(4000);
I INT;
BEGIN
STARTTIME := TO_DATE(P_STARTTIME,'YYYY-MM-DD HH24:MI:SS');