SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

json dot-notation query problem

user2545677Aug 12 2014 — edited Aug 13 2014

I use sql developer 4.0.1(my oracle client 12.1.0.1) connect to oracle database 12.1.0.2 in another server.

I have a tjson table with a json column of varchar2 type.

I use following sql: select info from tjson where info is json and info is not null; everything goes fine and I get the result: {"attr1":1,"attr2":"Hasdjlajjaslkdfjawr！","attr3":[1,2,3,4]}

When I use sql: select info.attr1 from tjson where info is json and info is not null; I got error said: "info"."attr1", invalid identifier

This post has been answered by odie_63 on Aug 12 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2014

Added on Aug 12 2014

6 comments

1,007 views