In
the previous posting of this series we learned how to store JSON
data in the Oracle database.
Now let’s query it.
First
let’s run these statements to create a table and inserts two
rows with JSON data:
DROP TABLE colorTab;
CREATE TABLE colorTab (
id NUMBER,
color VARCHAR2(32767),
CONSTRAINT ensure_json CHECK (color IS
JSON));
INSERT INTO colorTab VALUES(1, '
{
"name":"black",
"rgb":[0,0,0],
"hex":"#000000"
}
');
INSERT INTO colorTab VALUES(2, '
{ "name":...