以上命令在DOS命令操作（CMD）:
SQL> select &year||'-'||lpad(rownum,2,'0') yyyymm 2 from dual 3 connect by rownum<=12 4 / 输入 year 的值: 2012 原值 1: select &year||'-'||lpad(rownum,2,'0') yyyymm 新值 1: select 2012||'-'||lpad(rownum,2,'0') yyyymmSQL> select &year||'-'||lp
