-- 좀 애매하네요.. 다른 샘플이 더 있으면 좋은데 WITH T AS ( SELECT 'G06000' SRT FROM DUAL UNION ALL SELECT 'G06000TR01' FROM DUAL UNION ALL SELECT 'G06320' FROM DUAL UNION ALL SELECT 'G06320TR01' FROM DUAL UNION ALL SELECT 'G06340' FROM DUAL UNION ALL SELECT 'G06340TR01' FROM DUAL ) SELECT * FROM T ORDER BY LENGTH(SRT) , SRT