An Introduction to JSON in Oracle Databases

[@oegidio]

Excellent doc, thanks for the job

[@SkillbuildersUS]

Thank you. Check out our channel page and/or website for hundreds more free tutorials. skillbuilders.com/free-oracle-tutorials/

[@farisdurrani]

Can you share the script used in this presentation?

[@SkillbuildersUS]

really sorry for the delay. The scripts are available here skillbuilders.com/course/how-to-use-json-in-oracle-databases/

[@Saritha_Dhandapani]

How to store JSON in blob ?

[@geoffreywiland3120]

In the CREATE TABLE command, just specify BLOB as the datatype. If you input character data Oracle will convert the data into a BLOB before storing it in the database. But note that when retrieving the data, you will get BLOB data which by default will be displayed in hexadecimal. So, upon retrieval you should you use a conversion function to convert the BLOB back to VARCHAR2 or CLOB. For example: utl_raw.cast_to_varchar2(…blob data…) to_clob(…blob data…)