create or replace procedure delete_communication_c IS
usercount number;
cursor cur is
select id from communication_changeduser where modifytime<add_months(sysdate,-1);
BEGIN
for curitem in cur
loop
delete from communication_changeduser where id=curitem.id;
end loop;
commit;
end delete_communication_c;
select MODIFYTIME from communication_changeduser;
MODIFYTIME
02-9月 -10 08.00.44.000000 下午
select T.COLUMN_NAME,T.DATA_TYPE from dba_tab_columns t where t.TABLE_NAME='COMMUNICATION_CHANGEDUSER';
1 ID NVARCHAR2
2 USERCODE NVARCHAR2
3 MODIFYTIME TIMESTAMP(6)
4 OPERTYPE NVARCHAR2
5 USERTYPE NVARCHAR2