求一个oracle语句

Question

select free_res_val from test
{2092149012,54791011,6033391,579,10000636311767,12780,20110501000000,20110601000000:295080,900000}
{2092149012,54791011,6033391,579,10000636311767,23460,20110501000000,20110601000000:307860,900000}
{2092149012,54791011,6033391,579,10000636311767,28860,20110501000000,20110601000000:422280,900000}
{2092149012,54791011,6033391,579,10000636311767,12000,20110501000000,20110601000000:481680,900000}
{2092149012,54791011,6033391,579,10000636311767,12300,20110501000000,20110601000000:493680,900000}
{2092149012,54791011,6033391,579,10000636311767,8700,20110501000000,20110601000000:529200,900000}
{2092149012,54791011,6033391,579,10000636311767,1500,20110501000000,20110601000000:542220,900000}
{2092149012,54791011,6033391,579,10000636311767,28860,20110501000000,20110601000000:553020,900000}
{2092149012,54791011,6033391,579,10000636311767,21480,20110501000000,20110601000000:581880,900000}
{2092149012,54791011,6033391,579,10000636311767,28860,20110501000000,20110601000000:603360,900000}
{2092149012,54791011,6033391,579,10000636311767,24240,20110501000000,20110601000000:632220,900000}
{2092149012,54791011,6033391,579,10000636311767,28860,20110501000000,20110601000000:656460,900000}
{2092149012,54791011,6033391,579,10000636311767,2040,20110501000000,20110601000000:685320,900000}
{2092149012,54791011,6033391,579,10000636311767,9300,20110501000000,20110601000000:687360,900000}
{2092149012,54791011,6033391,579,10000636311767,28860,20110501000000,20110601000000:696660,900000}
{2092149012,54791011,6033391,579,10000636311767,16920,20110501000000,20110601000000:725520,900000}
{2092149012,54791011,6033391,579,10000636311767,28860,20110501000000,20110601000000:742440,900000}
{2092149012,54791011,6033391,579,10000636311767,25320,20110501000000,20110601000000:781200,900000}
{2092149012,54791011,6033391,579,10000636311767,3060,20110501000000,20110601000000:806520,900000}
{2092149012,54791011,6033391,579,10000636311767,23340,20110501000000,20110601000000:809580,900000}
{2092149012,54791011,6033391,579,10000636311767,7980,20110501000000,20110601000000:868260,900000}
{2092149012,54791011,6033391,579,10000636311767,18060,20110501000000,20110601000000:876240,900000}
{2092149012,54791011,6033391,579,10000636311767,47340,20110501000000,20110601000000:331320,900000}
{2092149012,54791011,6033391,579,10000636311767,43620,20110501000000,20110601000000:378660,900000}
{2092149012,54791011,6033391,579,10000636311767,30540,20110501000000,20110601000000:451140,900000}
{2092149012,54791011,6033391,579,10000636311767,23220,20110501000000,20110601000000:505980,900000}
{2092149012,54791011,6033391,579,10000636311767,4320,20110501000000,20110601000000:537900,900000}
{2092149012,54791011,6033391,579,10000636311767,9300,20110501000000,20110601000000:543720,900000}
{2092149012,54791011,6033391,579,10000636311767,9900,20110501000000,20110601000000:771300,900000}
{2092149012,54791011,6033391,579,10000636311767,35340,20110501000000,20110601000000:832920,900000}
{2092149012,54791011,6033391,579,10000636311767,5700,20110501000000,20110601000000:894300,900000}需要取出的结果为第五个逗号和第六个逗号之间的数据，即取出如下数据，要怎么取数啊，请大家帮忙看看，谢谢
12780
23460
28860
12000
12300
8700
1500
28860
21480
28860
24240
28860
2040
9300
28860
16920
28860
25320
3060
23340
7980
18060
47340
43620
30540
23220
4320
9300
9900
35340
5700

Answer 1

select substr(free_res_val,instr(free_res_val,',',5)+1,instr(free_res_val,',',6)-instr(free_res_val,',',5)) from test

Answer 2

改个：
select substr(free_res_val,instr(free_res_val,',',1,5)+1,instr(free_res_val,',',1,6)-instr(free_res_val,',',5)) from test