Oracle造数

--FLT_CUSFL 客户授信总量表
-- Created on 2015/11/12 by ADMIN
declare
  -- Local variables here
  v_num NUMBER(4) := 1000;
begin
  -- Test statements here
  for v_counts in 1 .. 2 loop
    insert into FLT_CUSFL select
             s.CUSFL_BNKNO,      
             v_num || s.CUSFL_CUSNO,
             s.CUSFL_EFDT,
             s.CUSFL_CURNO,
             s.CUSFL_REMARK
        from FLT_CUSFL_TEMP s;
    commit;
    v_num := v_num + 1;
  end loop;

end;

 

-- Created on 9/10/2012 by USER11                                                                              
DECLARE
v_stindpty  VARCHAR2(14);  --发起行行号
v_rvindpty  VARCHAR2(14); --接收行行号
v_msgid VARCHAR2(35);  --'2013032403299604'
v_stdpty VARCHAR2(14); --发起清算行行号
v_rvdpty VARCHAR2(14);  --接收清算行行号
--(0000,PR03,PR04,PR09,PR11,PR12,PR01,PR00,PR02,PR08,PR07,PR06,PR05,PR10,PR24,PR21,PR13,PR23,PR22,PR25,PR32)
v_date DATE := to_date('2012-06-01','yyyy-mm-dd');
v_num NUMBER(8) := 10000000;
v_num3 number(18,2) := 50000.00;
v_temp VARCHAR2(8);
BEGIN
for v_days in 1..15
LOOP
v_temp := to_char(v_num);
v_stindpty := '105521000029';
v_rvindpty := '105521000012';
--'105521000029' 105100098013  105121000016 105451000016 105221000013 105290028005  105581000018  301290050012 --105521000012
v_stdpty := '105521000012';
v_rvdpty := '302100011106';
for v_counts in 1..33333
loop
v_num := v_num + 1;                                                       
v_temp   := to_char(v_num);
v_msgid  := concat('msgid_06', v_temp);
  INSERT INTO bc_dtl_batqry
  (  
  STINDPTY,       
  RVINDPTY,       
  MSGID,          
  SRCCHNNL,       
  DESCHNNL,       
  SENDTIME,                          
  RCVTM,          
  STDPTY,         
  RVDPTY,         
  SYSCD,          
  RMKINF,         
  TRANSBTNM,      
  ACCOUNTCOUNT,   
  STATES,         
  ENDDT,                            
  INDBDATE,                                                                                 
  DATAMONTH)      
  values                                                    
    (
  v_stindpty,                  
  v_rvindpty,                  
  v_msgid,                     
  'NPC',                       
  'BEPS',                      
  to_char(v_date,'yyyy-mm-dd'),
  to_char(v_date,'yyyy-mm-dd'),
  v_stdpty,                    
  v_rvdpty,                    
  'BEPS',                      
  '',                          
  '',                          
  1,                           
  '0',                         
  to_char(v_date,'yyyy-mm-dd'),
  to_char(v_date,'yyyy-mm-dd'),
  '06'                                                                                                                              
    );                                                                                                                            
    end loop;                                                                                                                         
  v_date:=v_date + 1;                                                                                  
  END LOOP;                                                                                            
END;