declare
  v_sql varchar2(2000);
begin
  -- 文书业务主表
  execute immediate 'truncate table nrd_head';
  -- 文书业务子表
  execute immediate 'truncate table nrd_item';
  -- 文书业务数据表
  for v_t in (select table_name from user_tables where table_name like '%NRD_DATA_%')
  loop
    v_sql := 'truncate table ' || v_t.table_name;
   -- dbms_output.put_line(v_sql);
    execute immediate v_sql;
  end loop;
  -- 文书护理措施表
  execute immediate 'truncate table nur_data_intervention';
  -- 文书留痕表
  execute immediate 'truncate table nur_data_records';
  -- 文书共享元素表
  execute immediate 'truncate table nrd_data_share_record';
  -- 文书数字签名表
  --truncate table nrd_ca_sign_data;
  -- 文书任务记录
  execute immediate 'truncate table nur_doc_record_flow';
  
  -- 交接班主表
  execute immediate 'truncate table nur_handover_rec';
  -- 交接班表头统计
  execute immediate 'truncate table nur_handover_rec_add';
  execute immediate 'truncate table nur_handover_qt_total';
  -- 交接班明细
  execute immediate 'truncate table nur_handover_detl';
  
  --交接历史保存表
  execute immediate 'truncate table nur_handover_history';
  
  -- 患者交接
  execute immediate 'truncate table pa_handover';
  execute immediate 'truncate table pa_info';
  
  -- 业务日志表
  execute immediate 'truncate table event_log';
  -- 流程实例表
  execute immediate 'truncate table flow_instance';
  -- 流程实例明细表
  execute immediate 'truncate table flow_instance_item';
  
  -- 护嘱表
  execute immediate 'truncate table nur_general_order';
  -- 护嘱明细表
  execute immediate 'truncate table nur_yz_occ_record';
  execute immediate 'truncate table nur_yz_occ_record_b';
  
  -- 体征采集表
  execute immediate 'truncate table tc_col';
  -- 体征采集明细表
  execute immediate 'truncate table tc_col_item';
  
end;