oracle 小集

1. 动态sql
sql_string:=' select sysdate from dual'
execute immediate  sql_string

2.存储过程例子

create or replace procedure p_test2 as

begin
for m_for in 1..20000
loop
 insert
   into t_mkt_vipuser
  (vipid, vipnumber, mms_inceptmaxnum_day, sms_inceptmaxnum_day, wap_inceptmaxnum_day, mms_inceptmaxnum_week, sms_inceptmaxnum_week, wap_inceptmaxnum_week, mms_inceptmaxnum_month, sms_inceptmaxnum_month, wap_inceptmaxnum_month)
values
  (1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  commit;
  end loop;
 

for m_for in 1..10
  loop
  dbms_output.put_line('循环测试:'||m_for);
  end loop;

end;

3.插入数据时，不写日志 insert /*+ append nologging */  into