15.10 - Example: JSONExtractValue with NULL Results - 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

This example shows the JSONExtractValue method returning NULL results. This query gets the job associated with each person.

JSONExtractLargeValue can be substituted for JSONExtractValue.
SELECT eno, edata.JSONExtractValue('$..job')
FROM my_table
ORDER BY 1;

Result:

ENO edata.JSONExtractValue(…)
---------------------------------
1   programmer
2   ?
3   CPA
4   small business owner