JSON_VALUE Function (JSON)

最新推荐文章于 2025-03-15 14:55:10 发布

全岛铁盒2023

最新推荐文章于 2025-03-15 14:55:10 发布

阅读量738

点赞数

分类专栏： sap hana 文章标签： json

本文链接：https://blog.youkuaiyun.com/wangbanmin/article/details/122389901

版权

sap hana 专栏收录该内容

15 篇文章

订阅专栏

本文通过多个示例演示如何使用SQL语句中的JSON_VALUE函数从JSON对象中提取特定值。包括简单的键值提取、处理嵌套结构、默认值设置及错误处理等场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

The following statement returns a value of 10:

SELECT JSON_VALUE('{"item1":10}', '$.item1') AS "value" FROM DUMMY;
The following statement returns a value of 5:

SELECT JSON_VALUE('{"item1":{"sub1":10}, "item2":{"sub2":5}, "item3":{"sub3":7}}', '$.*.sub2') AS "value" FROM DUMMY;
The following statement returns a value of 0:

SELECT JSON_VALUE('[0, 1, 2, 3]', '$[0]') AS "value" FROM DUMMY;
The following statement returns the value "No last name found":

SELECT JSON_VALUE('{"firstname":"John"}', '$.lastname' DEFAULT 'No last name found' ON EMPTY) AS "Last Name" FROM DUMMY;
The following statement causes a type conversion error to demonstrate the behavior for ERROR ON ERROR:

SELECT JSON_VALUE('{"item":"string"}', '$.item' RETURNING DECIMAL ERROR ON ERROR) AS "Item" FROM DUMMY;
The following statement demonstrates what happens when there is no value (the object does not have the name "last name"):

SELECT JSON_VALUE('{"firstname":"John"}', 'strict $.lastname' ERROR ON ERROR) AS "Last Name" FROM DUMMY;