Oracle

Oracle Pro Members Standard Members

Projecting JSON Data Into Relational Format in Oracle Database

by

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
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Querying Financial Data From Yahoo! Finance From Within Oracle Database

by

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
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Accessing Google Searches From Within Oracle Database

by

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
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Using SQL/XML functions XMLExists and XMLCast

by

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
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Using XQuery To Access XML And Relational Data

by

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
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Fabricating Data Sets

by

Fabricating Data Sets You often need to fabricate a data set when it comes to creating a report showing daily results for each day in a certain range, regardless of whether there was an activity on a particular day or not. That being said, you need to build a query that will produce a row for each day within a...

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
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Multi-level Aggregation

by

Multi-level Aggregation You perform a multi-level aggregation when you need to combine data from different levels of aggregation. In this article, you’ll look at an example of how you might perform a multi-level aggregation within a single SQL query that contains subqueries, sending the aggregated data from the inner to the higher level of the query and combining the aggregated...

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
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Combining Aggregated Data With Inline Views

by

Combining Aggregated Data With Inline Views If your responsibility is to compose the queries producing aggregated data, you no doubt know that it’s not always possible to get the job done with a simple query – a one that contains subqueries, such as inline views, may be required. This article illustrates how you might use inline views as a way...

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
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

How To Not Include a Column From The SELECT List In The GROUP BY Clause

by

How To Not Include a Column From The SELECT List In The GROUP BY Clause Sometimes you don’t need to group by each column or expression included in the SELECT list of the query. For example, you may want to not include ROWNUM in the GROUP BY clause in spite of the fact that it appears in the SELECT list....

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
Already a member? Log in here
Continue Reading →
1 2 3 4 5 6 7