1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
SQL> ed
écrit file afiedt.sql
1 WITH t AS (
2 SELECT '2011-10001' cd FROM DUAL UNION ALL
3 SELECT '2011-9999' FROM DUAL UNION ALL
4 SELECT '2010-11111' FROM DUAL)
5 SELECT substr(cd, 1, 4), lpad(substr(cd, instr(cd, '-') + 1), 12, '0')
6 FROM t
7* ORDER BY substr(cd, 1, 4), lpad(substr(cd, instr(cd, '-') + 1), 12, '0')
SQL> /
SUBSTR(CD,1,4) LPAD(SUBSTR(CD,INSTR(CD,'-')+1),12,'0')
---------------- ------------------------------------------------
2010 000000011111
2011 000000009999
2011 000000010001 |
Partager