已知字段sec_info 的内容为[{"stkCode":"112267.SH","STK":"22a"}]字典格式， oracle如何SELECT读取STK后的值22a

你可以使用以下的SQL语句来查询字段sec_info中STK后的值22a:

SELECT JSON_VALUE(sec_info, '$.STK') AS STK_value
FROM 表名
WHERE JSON_VALUE(sec_info, '$.stkCode') = '112267.SH';

这个SQL语句使用了JSON_VALUE函数来提取sec_info字段中STK的值，并且使用了JSON_VALUE函数来判断stkCode是否等于'112267.SH'。<span class="em">1</span><span class="em">2</span>
#### 引用[.reference_title]
- *1* [服务报错:java.sql.SQLException: Field ‘***‘ doesn‘t have a default value](https://blog.csdn.net/qq_43842093/article/details/125016255)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [delphi股票行情二次开发](https://download.csdn.net/download/larrywoo/3336391)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]