Check out URL_NINJA written by a friend of mine Morten Egan.
https://github.com/morten-egan/url_ninja But if you want SQL, here's some samples
1) Get the pairs
SQL> with t as
2 ( select 'http://192.168.201.242:8000/express_get?time=XXXXX&from=YYYYY&to=JJJJJ&Id_agent=LLLLLL&spent=1234&qualifId=HHHHH&compagneId=UUUUUU' x from dual )
3 ,
4 params as
5 ( select '&'||substr(x,instr(x,'?')+1) p from t )
6 select
7 regexp_substr (p, '[^&]+', 1, level)
8 from params
9 connect by level <= regexp_count(p,'&');
REGEXP_SUBSTR(P,'[^&]+',1,LEVEL)
----------------------------------------------------------------------------------------------------------------------------------
time=XXXXX
from=YYYYY
to=JJJJJ
Id_agent=LLLLLL
spent=1234
qualifId=HHHHH
compagneId=UUUUUU
2) Get the key/values
SQL> with t as
2 ( select 'http://192.168.201.242:8000/express_get?time=XXXXX&from=YYYYY&to=JJJJJ&Id_agent=LLLLLL&spent=1234&qualifId=HHHHH&compagneId=UUUUUU' x from dual )
3 ,
4 params as
5 ( select '&'||substr(x,instr(x,'?')+1) p from t ),
6 pairs as (
7 select
8 regexp_substr (p, '[^&]+', 1, level) pair
9 from params
10 connect by level <= regexp_count(p,'&')
11 )
12 select
13 substr(pair,1,instr(pair,'=')-1) p1,
14 substr(pair,instr(pair,'=')+1) p2
15 from pairs;
P1 P2
-------------------- --------------------
time XXXXX
from YYYYY
to JJJJJ
Id_agent LLLLLL
spent 1234
qualifId HHHHH
compagneId UUUUUU