社区
Oracle
帖子详情
oracle 12C JSON的json_value,json_query解析长度问题
fg19941101
2018-05-30 04:52:32
在数据库中要解析一段json.但json的数据很大,有几百的字段值。
在用json_value或json_query解析时,只有前面部分字段可以解析得到值;
后面解析的返回都为null.
查找很多资料都没找到原因。并且也没有想到一个好的方法解决。
1.这种现象原因?
2.有哪些方法可以解决这种问题?
谢谢!
...全文
3166
3
打赏
收藏
oracle 12C JSON的json_value,json_query解析长度问题
在数据库中要解析一段json.但json的数据很大,有几百的字段值。 在用json_value或json_query解析时,只有前面部分字段可以解析得到值; 后面解析的返回都为null. 查找很多资料都没找到原因。并且也没有想到一个好的方法解决。 1.这种现象原因? 2.有哪些方法可以解决这种问题? 谢谢!
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
3 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
fg19941101
2018-06-05
打赏
举报
回复
已解决,感谢各位!
解决方式:如下:
declare
v_json_clob clob;---定义一个clob,来存放json类容
v_value varchar2(300);
begin
v_json_clob := '一段内容很多的json';
--再去解析就可以了
v_value := JSON_VALUE(v_json_clob,'$.busiData.md_cashflow[10].due_date');
dbms_output.put_line(v_value ||'----'||'10');
dbms_output.put_line(dbms_lob.getlength(v_json_clob));
end;
yuzhi5611062
2018-06-01
打赏
举报
回复
我也遇到这个问题 楼主解决了吗?
卖水果的net
2018-05-31
打赏
举报
回复
方便把数据贴上来吗?
unidac_7_1_4_pro DELPHI 10 Tokyo
7.1.4 29-Sep-17 InterBase data provider Bug with the "Input parameter mismatch" error for procedure is fixed Bug with transactions when working with Firebird 2.5 is fixed 7.1.3 19-Sep-17 The performance of TVirtual
Query
is significantly improved Application-defined functions in TVirtual
Query
are supported Application-defined collations in TVirtual
Query
are supported AutoInc fields in TVirtualTable are supported Bug with assertion failure when updating a record in TVirtual
Query
is fixed Bug with compatibility with TkbmMemTable in TVirtual
Query
is fixed Bug with complex WHERE clauses that have several string fields in TVirtual
Query
is fixed Bug with selecting from a dataset with a single record in TVirtual
Query
is fixed Bug with generating SQL for batch updates is fixed Bug with the Locate method for non-Windows platforms in Lazarus is fixed Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed Bug with accessing a product help from the IDE menu is fixed Bug with recreating fields when calling Open after Prepare is fixed Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed Bug with AV failure when using calculated fields in TClientDataset is fixed Bug with a key violation error when executing batch operations is fixed Bug with Assert when calling the Locate method in the SmartFetch mode is fixed Bug with using DAC components in DataModule for Linux is fixed Cloud data providers BigCommerce provider is added Dynamics CRM provider is added FreshBooks provider is added Magento provider is added MailChimp provider is added NetSuite provider is added QuickBooks provider is added Salesforce provider is added Salesforce Marketing Cloud provider is added SugarCRM provider is added Zoho CRM provider is added
Oracle
data provider
Oracle
12c
connection modes (SYSBACKUP, SYSDG, SYSKM) in the Direct mode are supported OS authentication in the Direct mode is supported NChar literal replacement is supported CLOB parameters behavior when UnicodeEnvironment=True is improved Bug with lost chars in a parameter
value
when ConvertEOL=True is fixed SQLServer data provider Bug with processing varchar fields when AutoTranslate is True in the Direct mode is fixed Bug with processing a field with alias for
query
with the JOIN statement is fixed Bug with date and time fractional seconds precision when DescribeParams = True is fixed MySQL data provider Azure Database for MySQL is supported
JSON
data type is supported InterBase data provider Support for Firebird on Android platform is added Support for Firebird 3 packages is added Aliases handling in the RETURNING clause is supported The WireCompression connection parameter for Firebird 3 is supported Bug with using BLOB data type in batch operations is fixed Bug with the OnBackupProgress event handler in TUniDADump is fixed Bug with using batch parameters of the Bytes type is fixed Bug with closing a connection that has an active transaction for Firebird 3 is fixed Bug with recreating a connection on Linux and mobile platforms is fixed PostgreSQL data provider SSPI authentication is supported Processing GUID data type for the TGuidField class is improved SQLite data provider Now the Direct mode is based on the SQLite engine version 3.20.0 Custom SQL aggregate functions are supported Bug with opening an existing database on iOS 64 is fixed Bug with detecting field types is fixed Bug with international symbols in non-Unicode Delphi versions is fixed Bug with low performance of the LoadFromDataSet method of the Loader component is fixed Bug with index backup using the Dump component when the TableNames property is set is fixed DBF data provider The CodePage specific options are added The ConnectMode specific options are added Bug with using CDX indexes is fixed DB2 data provider The DECFLOAT data type is supported
unidac_7_1_4_pro DELPHI 10 Berlin
7.1.4 29-Sep-17 InterBase data provider Bug with the "Input parameter mismatch" error for procedure is fixed Bug with transactions when working with Firebird 2.5 is fixed 7.1.3 19-Sep-17 The performance of TVirtual
Query
is significantly improved Application-defined functions in TVirtual
Query
are
Oracle
12C
数据库安装
介绍
Oracle
12c
数据库安装在Linux操作系统下的安装过程
Unidac Pro 7.1.4 XE8
7.1.4 29-Sep-17 InterBase data provider Bug with the "Input parameter mismatch" error for procedure is fixed Bug with transactions when working with Firebird 2.5 is fixed 7.1.3 19-Sep-17 The performance of TVirtual
Query
is significantly improved Application-defined functions in TVirtual
Query
are supported Application-defined collations in TVirtual
Query
are supported AutoInc fields in TVirtualTable are supported Bug with assertion failure when updating a record in TVirtual
Query
is fixed Bug with compatibility with TkbmMemTable in TVirtual
Query
is fixed Bug with complex WHERE clauses that have several string fields in TVirtual
Query
is fixed Bug with selecting from a dataset with a single record in TVirtual
Query
is fixed Bug with generating SQL for batch updates is fixed Bug with the Locate method for non-Windows platforms in Lazarus is fixed Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed Bug with accessing a product help from the IDE menu is fixed Bug with recreating fields when calling Open after Prepare is fixed Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed Bug with AV failure when using calculated fields in TClientDataset is fixed Bug with a key violation error when executing batch operations is fixed Bug with Assert when calling the Locate method in the SmartFetch mode is fixed Bug with using DAC components in DataModule for Linux is fixed Cloud data providers BigCommerce provider is added Dynamics CRM provider is added FreshBooks provider is added Magento provider is added MailChimp provider is added NetSuite provider is added QuickBooks provider is added Salesforce provider is added Salesforce Marketing Cloud provider is added SugarCRM provider is added Zoho CRM provider is added
Oracle
data provider
Oracle
12c
connection modes (SYSBACKUP, SYSDG, SYSKM) in the Direct mode are supported OS authentication in the Direct mode is supported NChar literal replacement is supported CLOB parameters behavior when UnicodeEnvironment=True is improved Bug with lost chars in a parameter
value
when ConvertEOL=True is fixed SQLServer data provider Bug with processing varchar fields when AutoTranslate is True in the Direct mode is fixed Bug with processing a field with alias for
query
with the JOIN statement is fixed Bug with date and time fractional seconds precision when DescribeParams = True is fixed MySQL data provider Azure Database for MySQL is supported
JSON
data type is supported InterBase data provider Support for Firebird on Android platform is added Support for Firebird 3 packages is added Aliases handling in the RETURNING clause is supported The WireCompression connection parameter for Firebird 3 is supported Bug with using BLOB data type in batch operations is fixed Bug with the OnBackupProgress event handler in TUniDADump is fixed Bug with using batch parameters of the Bytes type is fixed Bug with closing a connection that has an active transaction for Firebird 3 is fixed Bug with recreating a connection on Linux and mobile platforms is fixed PostgreSQL data provider SSPI authentication is supported Processing GUID data type for the TGuidField class is improved SQLite data provider Now the Direct mode is based on the SQLite engine version 3.20.0 Custom SQL aggregate functions are supported Bug with opening an existing database on iOS 64 is fixed Bug with detecting field types is fixed Bug with international symbols in non-Unicode Delphi versions is fixed Bug with low performance of the LoadFromDataSet method of the Loader component is fixed Bug with index backup using the Dump component when the TableNames property is set is fixed DBF data provider The CodePage specific options are added The ConnectMode specific options are added Bug with using CDX indexes is fixed DB2 data provider The DECFLOAT data type is supported
UniDAC 7.1.4
Product Description Universal Data Access Components (UniDAC) is a library of components that provides direct access to most popular database servers from Delphi, Delphi for .NET and, C++Builder. UniDAC can work with such servers as
Oracle
, Microsoft SQL Server, MySQL, Interbase, Firebird. The UniDAC library is designed to help programmers develop faster and cleaner cross-database applications. UniDAC is a complete replacement for such standard universal technology as dbExpress. UniDAC is a handy in use and efficient data access solution bringing into play many features specific to each server. Requirements UniDAC is a product joining functionality of such data access solutions as ODAC, SDAC, MyDAC, and IBDAC. Requirements of UniDAC depend only on used providers. Detailed requirements for each provider can be found in the Requirements topic in the UniDAC Help documentation. Installation Compiled versions of UniDAC are installed automatically by the UniDAC Installer for all supported IDEs. Versions of UniDAC with Source Code must be installed manually. For more information, see the Installation topic of the UniDAC Help documentation. It is important to know that UniDAC, ODAC, SDAC, MyDAC, and IBDAC use the common base packages, so product compatibility is provided for the current build only. In the other words, if you upgrade one of the installed providers, it may conflict with older builds of other products. In order to continue using the products simultaneously, you should upgrade all of them at the same time. 7.1.4 29-Sep-17 InterBase data provider Bug with the "Input parameter mismatch" error for procedure is fixed Bug with transactions when working with Firebird 2.5 is fixed 7.1.3 19-Sep-17 The performance of TVirtual
Query
is significantly improved Application-defined functions in TVirtual
Query
are supported Application-defined collations in TVirtual
Query
are supported AutoInc fields in TVirtualTable are supported Bug with assertion failure when updating a record in TVirtual
Query
is fixed Bug with compatibility with TkbmMemTable in TVirtual
Query
is fixed Bug with complex WHERE clauses that have several string fields in TVirtual
Query
is fixed Bug with selecting from a dataset with a single record in TVirtual
Query
is fixed Bug with generating SQL for batch updates is fixed Bug with the Locate method for non-Windows platforms in Lazarus is fixed Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed Bug with accessing a product help from the IDE menu is fixed Bug with recreating fields when calling Open after Prepare is fixed Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed Bug with AV failure when using calculated fields in TClientDataset is fixed Bug with a key violation error when executing batch operations is fixed Bug with Assert when calling the Locate method in the SmartFetch mode is fixed Bug with using DAC components in DataModule for Linux is fixed Cloud data providers BigCommerce provider is added Dynamics CRM provider is added FreshBooks provider is added Magento provider is added MailChimp provider is added NetSuite provider is added QuickBooks provider is added Salesforce provider is added Salesforce Marketing Cloud provider is added SugarCRM provider is added Zoho CRM provider is added
Oracle
data provider
Oracle
12c
connection modes (SYSBACKUP, SYSDG, SYSKM) in the Direct mode are supported OS authentication in the Direct mode is supported NChar literal replacement is supported CLOB parameters behavior when UnicodeEnvironment=True is improved Bug with lost chars in a parameter
value
when ConvertEOL=True is fixed SQLServer data provider Bug with processing varchar fields when AutoTranslate is True in the Direct mode is fixed Bug with processing a field with alias for
query
with the JOIN statement is fixed Bug with date and time fractional seconds precision when DescribeParams = True is fixed MySQL data provider Azure Database for MySQL is supported
JSON
data type is supported InterBase data provider Support for Firebird on Android platform is added Support for Firebird 3 packages is added Aliases handling in the RETURNING clause is supported The WireCompression connection parameter for Firebird 3 is supported Bug with using BLOB data type in batch operations is fixed Bug with the OnBackupProgress event handler in TUniDADump is fixed Bug with using batch parameters of the Bytes type is fixed Bug with closing a connection that has an active transaction for Firebird 3 is fixed Bug with recreating a connection on Linux and mobile platforms is fixed PostgreSQL data provider SSPI authentication is supported Processing GUID data type for the TGuidField class is improved SQLite data provider Now the Direct mode is based on the SQLite engine version 3.20.0 Custom SQL aggregate functions are supported Bug with opening an existing database on iOS 64 is fixed Bug with detecting field types is fixed Bug with international symbols in non-Unicode Delphi versions is fixed Bug with low performance of the LoadFromDataSet method of the Loader component is fixed Bug with index backup using the Dump component when the TableNames property is set is fixed DBF data provider The CodePage specific options are added The ConnectMode specific options are added Bug with using CDX indexes is fixed DB2 data provider The DECFLOAT data type is supported 7.0.2 15-May-17 Bug with using TVirtual
Query
with TVirtualTable is fixed Bug with processing NULL
value
s in the Loader component is fixed Bug with executing a
query
after executing a batch command is fixed Bug with executing a batch operation inside an explicitly started transaction is fixed Bug with using the AsGuid property is fixed
Oracle
data provider Bug with authentication in the Direct mode is fixed MySQL data provider Bug with processing DATETIME fields is fixed SQLServer data provider Bug with the "Invalid column name" error when editing a
query
with the JOIN statement is fixed InterBase data provider Bug with memory leak when using the SQLMonitor component is fixed PostgreSQL data provider Bug with AV failure after executing the Ping method is fixed SQLite data provider Bug with creating a database in the Direct Mode on Android is fixed
Oracle
17,082
社区成员
55,236
社区内容
发帖
与我相关
我的任务
Oracle
Oracle开发相关技术讨论
复制链接
扫一扫
分享
社区描述
Oracle开发相关技术讨论
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章