add tag
User 1791
Would it be possible for a section to be added to the db<>fiddle help with the following information?

Tips about handling db<>fiddle quirks when returning abstract datatypes (Oracle):

Examples:
1. SDO_GEOMETRY datatype (returns an empty dataset).
2. MDSYS.ST_GEOMETRY datatype (returns an empty dataset).
3. UDT (returns an empty dataset).
4. VARRAY datatype (returns an empty dataset).
5. Are there any other datatypes that return confusing values?

Possible solutions here: [db<>fiddle](https://dbfiddle.uk/?rdbms=oracle_18&fiddle=89ef0a9415750b1e5e79f4655b7f100d). *(Bear in mind I'm not an expert. So some of those proposed workarounds might be misguided.)*

**Would something like that be worth doing?**

----------------------------

Related: [Return a value/row when selecting SDO_GEOMETRY](https://topanswers.xyz/databases?q=2008)

This room is for discussion about this question.

Once logged in you can direct comments to any contributor here.

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.