I'm looking for a way to select a list of attribute names from a collection using SELECT, hopefully something that is just built into Oracle JSON support. (I know I can write some PLSQL that will parse the collection. I'm hopefully for something native to the JSON implementation as it might be more reliable in the long run.)
For example, I have a collection such as this stored in a column of a table as JSON.
{"year_name":CY2011,"quarter_name":Q2CY2011,"month_name":Apr-11}
and I would like a SELECT that returns:
year_name
quarter_name
month_name
Thanks,
- B