为啥没人留言@@

[size=large]进制转化[/size]10->16[code="sql"]select to_char(10,'XX') from dual[/code]16->10[code="sql"]select to_number(10,'XX')from dual[/code][size=large]去掉左右空格的函数[/size][code="sql"]up...

[code="sql"]update rms_cellset stateflag=to_char(sysdate,'yyyymmddhh24miss')where int_id in(select max(int_id)from rms_cell where MCC||'-'||MNC||'-'||LAC||'-'||CIin (select MCC||'-'||MNC...

[code="sql"]update rms_transne_2gx set (ZH_LABEL,NE_CODE,RELATED_EQUIPROOM,RELATED_RACK,SERIAL,PRODUCT,STATUS,CITY_ID,ENTER_TIME,CUT_TIME)=( select rms_transne.ZH_LABEL,rms_transne.N...

[code="sql"]-----更改设备SELECT 'RMS_TRANSCIR_USER->对网元编号提取，存入本端和对端num:' AS remark,TO_CHAR(CURRENT_DATE,'YYYY-MM-DD HH24:MI:SS') AS deal_time FROM dual;UPDATE RMS_TRANSCIR_USERSET SOURCE_NE=REPLAC...

[code="sql"]-----------------改变全角字符SELECT 'RMS_TRANSCIR_USER->改变全角字符:' AS remark,TO_CHAR(CURRENT_DATE,'YYYY-MM-DD HH24:MI:SS') AS deal_time FROM dual;UPDATE RMS_TRANSCIR_USER SET SOURCE_NE=RE...

[code="sql"]SELECT count(*) FROM RMS_NEPORT_2GX portWHERE exists ( SELECT 1 FROM RMS_TRANSCIR_USER usr,RMS_NEPORT_2GX port where usr.SOURCE_NE= port.SOURCE_NE_COL and usr.S...

对带 扩-X 的进行拆分[code="sql"]update RMS_TRANSCIR_USERset SOURCE_TRANS_PORT=substr(SOURCE_TRANS_PORT,instr(SOURCE_TRANS_PORT,'-',1)+1,instr(SOURCE_TRANS_PORT,'PQ',1)-instr(SOURCE_TRANS_PORT,'-',1)-1)|...

[code="sql"]update RMS_TRANSCIR_LOCALset SOURCE_NE=REMOTE_TRANS_EQU,REMOTE_TRANS_EQU=SOURCE_NE,SOURCE_TRANS_PORT=REMOTE_TRANS_PORT,REMOTE_TRANS_PORT=SOURCE_TRANS_PORTwhere SOURCE_NE not in (sele...

[code="sql"]update RMS_TRANSCIR_USER usr set usr.SOURCE_NE= ( select ne.OLD_NAME from RMS_TRANSNE ne where usr.remark=substr(ne.OLD_NAME,1,instr(ne.OLD_NAME,'-',1)-1)...

[code="sql"]UPDATE RMS_PATHSET ANENAME=ZNENAME,APTP=ZPTP,ACTP=ZCTP,ZNENAME=ANENAME,ZPTP=APTP,ZCTP=ACTP,ANENAME_COL=ZNENAME_COL,ZNENAME_COL=ANENAME_COL,ACITY_ID=ZCITY_ID,ZCITY_ID=ACITY_IDWHERE AC...