Loading…
This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
Sydney Oracle Meetup and APACOUC welcome you to the first Sydney OTN Day (Part of the 5th APAC OTN Tour).
View analytic
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 and see who's attending!

Limited Capacity seats available

Oracle 12c adds formal support for JSON data with the 12.1.0.2 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.

Speakers
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.


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

Attendees (19)