摘要:
CREATE PROCEDURE DELETE_Data()BEGIN delete FROM `new_energy_plc` where INPUTTIME<date_add(now(),interval-6 day); delete from cd_ret_well_collect where 阅读全文
摘要:
-- 定义要查询的表名DECLARE v_table_name VARCHAR2(100) := 'YOUR_TABLE_NAME'; v_sql VARCHAR2(4000); v_column_list VARCHAR2(4000);BEGIN -- 初始化列列表 v_column_list : 阅读全文