Loading JSON Through External Tables By Yuli Vasiliev The article illustrates the simplest way to load external JSON data to an Oracle database through external tables. The example provided uses the dump file containing JSON documents. This file comes with Oracle Database 12c as a sample. All you’ll need to do to follow the sample code provided in this article […]
Tag: XML
Using the XMLExists SQL/XML Function in a SELECT List
Using the XMLExists SQL/XML Function in a SELECT List By Yuli Vasiliev SQL/XML function XMLExists was introduced in Oracle Database 11g to eventually replace Oracle’s function existsNode. Unlike the existsNode though, XMLExists cannot be used in the SELECT list directly. However, you can still do that by wrapping it in a CASE expression. This article provides an example on how […]
Troubleshooting SQL Server 2014 XML Problems
Troubleshooting SQL Server 2014 XML Problems If you have problems with SQL Server 2014 XML, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 XML bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article […]
Projecting JSON Data Into Relational Format in Oracle Database
Projecting JSON Data Into Relational Format in Oracle Database By Yuli Vasiliev It is common for Web services and Web applications today to use JSON as a data-interchange format. Starting with release 12.1, Oracle Database supports JSON, allowing you to access JSON content stored either inside or outside of the database. This article explains how you might project JSON data...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Projecting JSON Data Into Relational Format in Oracle Database
Projecting JSON Data Into Relational Format in Oracle Database By Yuli Vasiliev It is common for Web services and Web applications today to use JSON as a data-interchange format. Starting with release 12.1, Oracle Database supports JSON, allowing you to access JSON content stored either inside or outside of the database. This article explains how you might project JSON data […]
Querying Financial Data From Yahoo! Finance From Within Oracle Database
Querying Financial Data From Yahoo! Finance From Within Oracle Database By Yuli Vasiliev As you no doubt know, Yahoo! Finance is a web site that provides financial information, including stock quotes, stock exchange rates, international market data, and much more. The article illustrates how you can receive financial data in XML format from Yahoo! Finance, issuing queries directly from within...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Accessing Google Searches From Within Oracle Database
Accessing Google Searches From Within Oracle Database By Yuli Vasiliev This article explains how you might use Google search results in programmatic ways, consolidating those results with database data. In particular, the article covers how you might use the Google Web Search API, accessing it from within SQL queries issued in Oracle Database. It is interesting to note that although...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Tips for using XML in SQL Server 2014
Tips for using XML in SQL Server 2014 Use SQLXML instead of Native XML Web Services. Beginning in SQL Server 2014, the Native XML Web Services is removed. So, you can no longer use CREATE ENDPOINT or ALTER ENDPOINT to add or modify SOAP/HTTP endpoints. Consider using the RAW mode of FOR XML queries, instead of AUTO or EXPLICIT modes....
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Undocumented SQL Server 2012 XML Stored Procedures
Undocumented SQL Server 2012 XML Stored Procedures SQL Server 2012 supports the following three undocumented XML system stored procedures: – sp_syscollector_validate_xml – sp_xml_schema_rowset – sp_xml_schema_rowset2 sp_syscollector_validate_xml The sp_syscollector_validate_xml system stored procedure is used to validate the XML collector. Syntax sp_syscollector_validate_xml [ @collector_type_uid = ] ‘collector_type_uid’, [ @name = ] ‘name’, [ @parameters = ] ‘parameters’ Arguments [ @collector_type_uid = ]...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Using XQuery To Access XML And Relational Data
Using XQuery To Access XML And Relational Data By Yuli Vasiliev This article provides an example of how you might query both XML and relational data within a single SQL query using Oracle XQuery, demonstrating the Oracle Database’s ability to combine together different format data. In particular, you’ll look at a query that retrieves data from the DEPARTMENTS relational table...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here