Oracle XQuery to Access XML/HTML Content From the Database By Yuli Vasiliev Oracle XQuery is one of the most widely used facilities provided by Oracle XML DB, allowing you to issue XQuery queries right from within SQL statements. It works like this. You pass an XQuery expression to a SQL/XML function, such as XMLQuery or XMLTable, querying either […]
Author: Yuli Vasiliev
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 […]
Using Oracle SQL Functions for JSON in Oracle Database 12c
Using Oracle SQL Functions for JSON in Oracle Database 12c By Yuli Vasiliev Oracle Database 12c introduces Oracle SQL functions for JSON as a key feature of the JSON support. With the help of these functions, you can query JSON data, project it relationally, and even index JSON content. This article gives some examples on how to use Oracle SQL […]
Taking Advantage of the OUTER JOIN Syntax
Taking Advantage of the OUTER JOIN Syntax By Yuli Vasiliev Back to Oracle Database 9i, the OUTER JOIN syntax was introduced to provide the ANSI-standard alternative to proprietary outer join operator (+). However, some people still don’t want to switch. This article provides an example that illustrates how the OUTER JOIN syntax compares favorably with the (+) operator. To walk […]
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 […]
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
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
Using SQL/XML functions XMLExists and XMLCast
Using SQL/XML functions XMLExists and XMLCast By Yuli Vasiliev This article reveals how you might use SQL/XML functions in your SQL statements accessing XML data, thus taking advantage of both SQL and XML in a single query. In particular, the article focuses on the XMLExists function that is used to evaluate the XQuery expression passed in, checking whether it returns...
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