json table example

1[
2	{
3		color: "red",
4		value: "#f00"
5	},
6	{
7		color: "green",
8		value: "#0f0"
9	},
10	{
11		color: "blue",
12		value: "#00f"
13	},
14	{
15		color: "cyan",
16		value: "#0ff"
17	},
18	{
19		color: "magenta",
20		value: "#f0f"
21	},
22	{
23		color: "yellow",
24		value: "#ff0"
25	},
26	{
27		color: "black",
28		value: "#000"
29	}
30]
31

1CopyCREATE TABLE j_purchaseorder
2  (id          VARCHAR2 (32) NOT NULL PRIMARY KEY,
3   date_loaded TIMESTAMP (6) WITH TIME ZONE,
4   po_document VARCHAR2 (23767)
5   CONSTRAINT ensure_json CHECK (po_document IS JSON));