select to_char(10,'XX') from dual

select to_number(10,'XX')from dual

update RMS_NEPORT_LOCAL set SLOT_NO_16=ltrim(SLOT_NO_16)

update RMS_NEPORT_LOCAL set SLOT_NO_16=rtrim(SLOT_NO_16)

update RMS_NEPORT_LOCAL set USER_LABEL='T2.'||PORTNO
where stateflag=0
and VENDOR like '烽火'
and SLOT_NO_16  like '4'
and CARD_TYPE in('E1','E1-16','E1-32B','E1-63','E1-63FW')
and SOURCE_NE in(
    select INT_ID from RMS_TRANSNE_LOCAL
    where STATEFLAG=0
    and MODEL_COL like '155 C'
)

select SIG_NE 网元,REMOTE_NAME 对端,SLC,TK_PORT_PHY,LINK_TYPE 端口 from RMS_LINK
where STATEFLAG=0
and SIG_NE like 'MYHLR3'
order by SIG_NE,REMOTE_NAME,SLC,TK_PORT_PHY

select SIG_NE 网元,REMOTE_NAME 对端,SLC,TK_PORT_PHY 端口 from RMS_LINK
where STATEFLAG=0
and REMOTE_NAME like 'MYHLR3'
order by REMOTE_NAME,SIG_NE,SLC,TK_PORT_PHY

select SOURCE_BUSI_EQU 本端,SOURCE_BUSI_PORT 端口,REMOTE_BUSSI_EQU 对端 from RMS_TRANSCIR 
where STATEFLAG=0
    and SOURCE_BUSI_EQU like 'MYHLR3'
order by REMOTE_BUSSI_EQU,SOURCE_BUSI_PORT