SELECT  LEFT('1-1-1' , 2 ) +

                 REPLICATE(0,2-LEN( (CASE WHEN LEN( '1-1-1') = 5 THEN SUBSTRING('1-1-1',3,1)
                                                                     WHEN  LEN( '1-1-1') = 6 THEN SUBSTRING('1-1-1',3,2) END)    + 1)) + 

                 CASE WHEN LEN( '1-1-1') = 5 THEN SUBSTRING('1-1-1',3,1) 
                             WHEN  LEN( '1-1-1') = 6 THEN SUBSTRING('1-1-1',3,2) END 

                +   RIGHT('1-1-1' ,2) FROM  DUAL

위 쿼리를 실행하면 원하는 결과값  '1-01-1' 나옴

위의 쿼리에서 '1-1-1' -> 컬럼 명 해주면 답 나올거임

ㅅㅅ

수정함

SELECT  REPLICATE(0,2-LEN( (CASE WHEN LEN( '1-1-1') = 5 THEN SUBSTRING('1-1-1',3,1)
                                                      WHEN  LEN( '1-1-1') = 6 THEN SUBSTRING('1-1-1',3,2) END)    + 1)) + 

                 CASE WHEN LEN( '1-1-1') = 5 THEN SUBSTRING('1-1-1',3,1)
                             WHEN  LEN( '1-1-1') = 6 THEN SUBSTRING('1-1-1',3,2) END   + '-' +

                 REPLICATE(0,2-LEN( (CASE WHEN LEN( '1-1-1') = 5 THEN SUBSTRING('1-1-1',3,1)
                                                                     WHEN  LEN( '1-1-1') = 6 THEN SUBSTRING('1-1-1',3,2) END)    + 1)) + 

                 CASE WHEN LEN( '1-1-1') = 5 THEN SUBSTRING('1-1-1',3,1)
                             WHEN  LEN( '1-1-1') = 6 THEN SUBSTRING('1-1-1',3,2) END  + '-'

                +    REPLICATE(0,2-LEN( (CASE WHEN LEN( '1-1-1') = 5 THEN SUBSTRING('1-1-1',3,1)
                                                                     WHEN  LEN( '1-1-1') = 6 THEN SUBSTRING('1-1-1',3,2) END)    + 1)) + 

                 CASE WHEN LEN( '1-1-1') = 5 THEN SUBSTRING('1-1-1',3,1)
                             WHEN  LEN( '1-1-1') = 6 THEN SUBSTRING('1-1-1',3,2) END    FROM  DUAL