The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
Thanks for the question.
Asked: January 07, 2019 - 12:05 pm UTC
Last updated: January 07, 2019 - 4:20 pm UTC
Version: 12.2
Viewed 1000+ times
create table t ( c1 varchar2(1000) check ( c1 is json ), vc int generated always as ( json_value ( c1, '$.attr' ) ) ) partition by list ( vc ) ( partition p1 values ( 1 ), partition p2 values ( 2 ) ); insert into t ( c1 ) values ( '{ "attr": 1 }' ); insert into t ( c1 ) values ( '{ "attr": 2 }' ); commit; select t.*, uo.subobject_name from t, user_objects uo where dbms_rowid.rowid_object ( t.rowid ) = uo.data_object_id order by 1; C1 VC SUBOBJECT_NAME { "attr": 1 } 1 P1 { "attr": 2 } 2 P2
The Oracle documentation contains a complete SQL reference.