reverse( )
-
[ORACLE] 문자열 자르기 substr( ) 활용DATABASE 2018. 11. 2. 17:17
1. 특수문자를 포함하여 뒤에 4자리는 제외하고 문자열 자르기select valfrom (select '1231244-111' as val from dualunion allselect '12312534444*341' as val from dualunion allselect '1231223523544_523' as val from dual) a select reverse(val) -- 문자열을 반대로from (select '1231244-111' as val from dualunion allselect '12312534444*341' as val from dualunion allselect '1231223523544_523' as val from dual) a select substr(reverse(val..