打印变量
DBMS_OUTPUT.put_line('ypurParam=='||yourParam);
给参数赋值 方法之一
select to_char(to_date('200707027','YYYYMMDD'),'Q') into yourParam from dual ;
DBMS_OUTPUT.put_line('ypurParam=='||yourParam);
给参数赋值 方法之一
select to_char(to_date('200707027','YYYYMMDD'),'Q') into yourParam from dual ;