lpad(rownum,5,'0')表示获取当前行号,保留5位前边用0填充例如
select '2020-' || lpad(rownum, 5, '0') as col from 表命;
2020-00001,
2020-00002,
2020-00003
lpad(rownum,5,'0')表示获取当前行号,保留5位前边用0填充例如
select '2020-' || lpad(rownum, 5, '0') as col from 表命;
2020-00001,
2020-00002,
2020-00003