SELECT SUBSTR(T.RAW_P_NO, REGEXP_INSTR(T.RAW_P_NO, '[^0]', 1))
, REGEXP_SUBSTR(T.RAW_P_NO, '[^0][[:ALNUM:]]*$')
, T.RAW_P_NO
FROM IF_ESQAWIN T;
3079686 3079686 000000000003079686
3000010 3000010 000000000003000010
3079686 3079686 000000000003079686
3000010 3000010 000000000003000010
3000010 3000010 000000000003000010
3000010 3000010 000000000003000010
3032858 3032858 000000000003032858
3079686 3079686 000000000003079686
3032935 3032935 000000000003032935
3076225 3076225 000000000003076225
3079686 3079686 000000000003079686
3000010 3000010 000000000003000010
3032858 3032858 000000000003032858
3032935 3032935 000000000003032935
3000010 3000010 000000000003000010
3000010 3000010 000000000003000010
정규식으로 문자열 추출
|
2018.11.07 14:19:25
|
2018.11.07 14:19:25
|
319
|
Aiden
Total of Attached file
0.00 Bytes of 0 files
2019.01.15
2019.01.05
2018.11.07
2018.08.06
2017.12.15
2017.09.07
2016.11.24
2016.10.20