15.10 - Examples: Unambiguous JSON Entity Reference - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

The following shows unambiguous examples of JSON entity reference usage.

Example

SELECT jsonCol.name
FROM test.jsonTable
WHERE id=1;
Result:
jsonCol.name
------------
Cameron

Example

SELECT jsonCol.numbers[1]
FROM test.jsonTable
WHERE id=1;
Result:
jsonCol.numbers[1]
------------------
2

Example

SELECT new JSON('{"name" : "Cameron"}').name;
Result:
new JSON('{"name" : "Cameron"}').name
-------------------------------------
Cameron