Drop the table if it already exists

drop table JSON_EXAMPLE1 

Create a table to contain JSON data.

create table JSON_EXAMPLE1(  
   PKEY NUMBER(2),  
   JSON_COLUMN VARCHAR2(64)  
) 

Insert Data

insert into JSON_EXAMPLE1 values (1, '{ "MyKey1" : "Value1", "MyKey2" : "Value2" }')  

Commit

commit 

REM Attempt to generate an JSON object with a Key called "MyObject" whose value is the JSON document. Note the value is a JSON String, not a JSON Object. One way of getting a JSON Object is to add an IS JSON constraint to the table. 

Attempt to use Simple Syntax for JSON on the column containing the JSON documents

select PKEY, ex.JSON_COLUMN.MyKey1, ex.JSON_COLUMN.MyKey2  
  from JSON_EXAMPLE1 ex 

REM In 18c we can force the database to treat VARCHAR2, CLOB and BLOB columns as JSON using TREAT( String as JSON) 

with MY_JSON_TABLE as 
( 
   select PKEY, TREAT(JSON_COLUMN as JSON) JSON_COLUMN 
     from JSON_EXAMPLE1 
) 
select PKEY, j.JSON_COLUMN.MyKey1, j.JSON_COLUMN.MyKey2 
  from MY_JSON_TABLE j 

create or replace view JSON_ENABLED_VIEW 
as  
select TREAT(JSON_COLUMN as JSON) JSON_COLUMN 
 from JSON_EXAMPLE1 

select j.JSON_COLUMN.MyKey1,j.JSON_COLUMN.MyKey2 
  from JSON_ENABLED_VIEW j 

select JSON_OBJECT('MyObject' value JSON_COLUMN) JSON 
  from JSON_EXAMPLE1 

select PKEY, JSON_OBJECT('MyObject' value TREAT(JSON_COLUMN as JSON)) JSON 
  from JSON_EXAMPLE1