king_moyu的博客

DROP PROCEDURE IF EXISTS customview_logs_pro; DELIMITER // CREATE PROCEDURE customview_logs_pro(IN counts BIGINT) BEGIN DECLARE i BIGINT DEFAULT 1; DECLARE total_count INT DEFAULT 1; DECLARE timestr V

create or replace procedure viewstat_logins_pro(In counts Bigint) language sql begin declare i Bigint default 1; --拼接随机时间 declare timestr varchar(19); declare from_user varchar(64); declare daytime Bi

create or replace procedure backup_logs_sp(status_flag out number) AS BEGIN insert into tablename1 select * from tablename2 where tablename2.create_time < trunc(sysdate-7); delete from tablename2 whe