I have multi-part SDO_GEOMETRIES in Oracle 18c. I can extract the parts as individual rows using the SDO_UTIL.EXTRACT_ALL() function: with cte as ( --Each part
buildingblocks
keycloak-operator
fortigate
twain
crypt
scrapy-pipeline
monogame
caption
phpcodesniffer
selecteditem
uidevice
long-parameter-list
declaration
context-free-grammar
tab-size
string-matching
asp.net-core-1.1
temporal-tables
llvm-clang
rebuild
cross-hair-label
dac
testrigor
interrupt
evict
image-scaling
jstat
delegating-constructor
generative-art
npm-login