Oracel LPAD RPAD 사용 예시 / 문서 번호 / 오라클 패드

SELECT  A.OT_SEQ 															  	  			otSeq
     ,	TO_CHAR(A.RGST_DT,'YYYY.MM.DD')    								  	  				rgstDt
     ,	(SELECT NAME FROM t_ad_user WHERE USE_YN = 'Y' AND SEQ = A.RGST_ID)					rgstId	
     ,	(SELECT NAME FROM t_ad_user WHERE USE_YN = 'Y' AND SEQ = A.APPROVER )    			approver
     ,	A.STATUS 															      			status   
     ,	A.PRJCT_NM 															  				prjctNm     
     ,	A.ETC 																      			etc   
     ,	A.ATCH_FILE_ID 														  				atchFileId
     ,	'OPEN-'||LPAD(A.OT_SEQ,5,'0')											  			docuNum
     ,	TO_CHAR(A.APPLY_DATE, 'YYYY.MM.DD')													applyDate
     ,	A.RGST_ID																			rgstSeq

  FROM   TABLE A
 WHERE   A.USE_YN='Y'	
   AND   A.OT_SEQ = #{otSeq}