Sydney OTN Day has ended
Sydney Oracle Meetup and APACOUC welcome you to the first Sydney OTN Day (Part of the 5th APAC OTN Tour).
Back To Schedule
Monday, November 30 • 09:50 - 10:35
JSON Support in Oracle 12c with John King LIMITED

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Limited Capacity seats available

Oracle 12c adds formal support for JSON data with the update released in the summer of 2014. While Oracle has supported XML data for years it does so with the special XMLType data type. Instead of a new data type, Oracle 12c stores JSON using standard Oracle character data (VARCHAR2, CLOB, BLOB). A JSON-specific “is JSON” test may be applied in CHECK constraints and WHERE clauses. Several JSON-specific functions are also provided including: JSON_EXISTS, JSON_QUERY, JSON_TABLE, and more. Attendees will learn how to create tables using JSON columns, how to INSERT data into JSON columns, how to query JSON data, and how to use JSON_TABLE to represent JSON data as “normal” relational data.

avatar for John King

John King

Partner, King Training Resources
John Jay King is partner in King Training Resources tailoring and conducting training since 1988 (www.kingtraining.com). John customizes courses in topics including Oracle, MAF, and ADF. John presents frequently at conferences including Oracle Open World, RMOUG, IOUG, UTOUG, AUSOUG, and UKOUG; he is an Oracle Ace Director, member of the Oak Table Network, and serves on the AZORA board... Read More →

Monday November 30, 2015 09:50 - 10:35 AEDT
Main Room

Attendees (0)