一、Oracle 带参数,无返回
create or replace PROCEDURE PRO_RLZY_RSHT_BGNR (OID VARCHAR)
AS
BEGIN
INSERT INTO TABLENAME
SELECT * FROM TABLENAME WHERE ID = OID ;
二、Mysql 带参数,有返回
CREATE DEFINER=`root`@`localhost` PROCEDURE `zjgl_lscx_hz`(in_begindate varchar(64),in_enddate varchar(64),in_partid varchar(50) )
BEGIN
DECLARE In_StartTime VARCHAR(64);
DECLARE In_StopTime VARCHAR(64);
DECLARE in_PartIDD VARCHAR(50);
if in_begindate is NULL or in_begindate ='' THEN
#set In_StartTime = timestamp(date_add(curdate(), interval - day(curdate()) + 1 day));##默认查询开始时间为当月1日
set In_StartTime = DATE_FORMAT( DATE_SUB(CURDATE(), INTERVAL 1 month), '%Y-%m-%d 00:00:00');##默认查询开始时间为前一个月开始
ELSE
SET