WITH T AS (SELECT 'http://baidu.com/new?word/pid=1726378/XXXX' STR FROM DUAL) SELECT SUBSTR(STR, INSTR(STR, 'pid=', 1) + 4 ,7) FROM T
