Tag: XML

Oracle

Loading JSON Through External Tables

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 […]

Oracle

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 […]

SQL Server

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 […]

Oracle Pro Members Standard Members

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.
Log In Register
Oracle Pro Members Standard Members

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.
Log In Register
Oracle Pro Members Standard Members

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.
Log In Register
Pro Members SQL Server Standard Members

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.
Log In Register
Pro Members SQL Server Standard Members

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.
Log In Register
Oracle Pro Members Standard Members

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.
Log In Register