Session_s的博客

jdbc:oracle:thin:＠ 。示例：使用SERVICE_NAME ：jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.4.1)(PORT=1528)))(CONNECT_DATA=(SERVICE_NAME=name1)))使用SID：jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(H

SELECT REGEXP_SUBSTR (‘aaaa,bbbb,cccc’, ‘[^,]+’, 1,rownum)from dual connect by rownum<=LENGTH (‘aaaa,bbbb,cccc’) - LENGTH (regexp_replace(‘aaaa,bbbb,cccc’, ‘,’, ‘’))+1;

select substr(aj.join_desc,instr(aj.join_desc,'"groupName":"')+length('"groupName":"'), length(substr(aj.join_desc,instr(aj.join_desc,'"groupName":"')++length('"groupName":"'))) -length(substr(substr(aj.join_desc,instr(aj.join_desc,'"group..

水电费