By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT geonameid
FROM json_table('[2593109,3336899,3114710,2521383,3336903,2593110,3336898,3336900,2593111,3336901,2519582,2593112,3336902,3336897,3117732,6362988,2513413,3115609,2593113]'
,'$[*]' columns(geonameId NUMBER path '$'))
| GEONAMEID |
|---|
| 2593109 |
| 3336899 |
| 3114710 |
| 2521383 |
| 3336903 |
| 2593110 |
| 3336898 |
| 3336900 |
| 2593111 |
| 3336901 |
| 2519582 |
| 2593112 |
| 3336902 |
| 3336897 |
| 3117732 |
| 6362988 |
| 2513413 |
| 3115609 |
| 2593113 |
begin
for i in (SELECT geonameid
FROM json_table('[2593109,3336899,3114710,2521383,3336903,2593110,3336898,3336900,2593111,3336901,2519582,2593112,3336902,3336897,3117732,6362988,2513413,3115609,2593113]'
,'$[*]' columns(geonameId NUMBER path '$')))
loop
dbms_output.put_line('Id: '||i.geonameid);
end loop;
end;
/
1 rows affected
dbms_output:
Id: 2593109
Id: 3336899
Id: 3114710
Id: 2521383
Id: 3336903
Id: 2593110
Id: 3336898
Id: 3336900
Id: 2593111
Id: 3336901
Id: 2519582
Id: 2593112
Id: 3336902
Id: 3336897
Id: 3117732
Id: 6362988
Id: 2513413
Id: 3115609
Id: 2593113