Several Simple oracle knowledge

1. for in the stored procedure, you can use for in. If you can enumerate for a in 1 .. 12. It is 12 cycles. Note that there are two vertices in the middle, not three. after insertion or deletion, remember to write commit; otherwise, the stored procedure is successfully executed, but the result remains unchanged. 3. if you want to extract a string and then obtain a value, you can write: select * from dim_hy hy where instr (',' | '2014, 3219,325 0' | ',', ',' | hy. hy_dm | ',')> 0; otherwise, you need to write the truncation function (not found in oracle) by ssg108.