【DM版本】:SQL> SELECT * FROM v$version;
行号 BANNER
1 DM Database Server 64 V8
2 DB Version: 0x7000d
3 03134284368-20250423-270902-20149
4 Msg Version: 43
5 Gsu level(5) cnt: 0
【操作系统】：麒麟V10
【CPU】:x86
【问题描述】*：发现jsonb相关函数是否仅为有限支持？
运行官方示例，处理常量字符串可以正常运行
但是处理某个列的时候，就会报错
试一下下面这个写法，看是否能实现需求
WITH T_DATA AS ( SELECT '[1,true,3.14,"STRTEST",[123,345,567],{"A":"BB","B":12344321}]' AS JDATA union all SELECT '[{"xx":"test1","yy":1212},{"xx":"test2","yy":3434}]' AS JDATA ) SELECT a.jdata,cast(b.value as varchar2),json_value(b.value,'$.yy') as value FROM T_DATA a ,jsonb_array_elements(a.JDATA) b