How to convert a JSON array into a set of rows in Oracle?

I want to convert a json array into a set of rows in Oracle.

Input:

'["a","b","c"]'

Output:

col_name
---------
a
b
c

PostgreSQL provides the function, jsonb_array_elements(jsonb) to do this.

How can I do this in Oracle 18c. Thank you.

Copyright Notice：Content Author:「xuange」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/61452345/how-to-convert-a-json-array-into-a-set-of-rows-in-oracle