Invitation to the Wedding of JSON and Relational Data [LRN1569].pdf

1、Invitation to the Wedding of JSON and Relational Data Kim Berg HansenKim Berg Hansen SQL&PL/SQL developer since 2000 Author of“Practical Oracle SQL”Cegal Danmark since 2022 Oracle ACE Director Core member of MASH Program Member of Symposium 42 SQL quizmaster at OCE in SQL Likes to cook and read sci-

2、fi Member of Danish Beer Enthusiasts Twitterkibeha Bloghttps:/kibeha.dk Other linkshttps:/linktr.ee/kibehaLogoDescription automatically generatedSelect from SQL quizzes on Oracle Dev Gym3 membership tiersConnect:oracleaceF experts helping peers globallyThe Oracle ACE Program recognizes and rewards c

3、ommunity members for their technical and community contributions to the Oracle communityNominateyourself or someone you know: more details on Oracle ACE Program:A tech powerhouse,specialized in energyAgendaInvitation to the Wedding ofJSON and Relational Data 12.1.0.2 JSON arrives 12.2 Courtship begi

4、ns 18 Going steady 19 Popping the question 21 Announcing engagement 23 The Wedding 23 Married lifeNOTE Code executed on a 23ai FREE instance version 23.4.12.1.0.2 JSON arrivesNative JSON support XML DB(!)Developers Guide:https:/ Oracle Database 12c Release 1 New Features:https:/ Changes for Oracle D

5、atabase SQL Language Reference:https:/ table products(id integer constraint products_pk primary key,name varchar2(20 char)not null,attribsblob check(attribs is json);Storage Store in VARCHAR2,CLOB or BLOB (A dedicated datatype comes later)IS JSON condition for predicate or check constraint BLOB has

6、advantages:No character encoding conversion JSON is always UTF-8 Half size of CLOB in multi-byte characterset database12.1.0.2insert into products values(4160,Reindeer Fuel ,142,utl_raw.cast_to_raw(data:OG:1057,FG:1012,IBU:33,ABV:5.1,malts:Maris Otter,Munich,Victory,Pale Chocolate,hops:Nugget,Fuggle