Using Oracle VM VirtualBox Templates By Yuli Vasiliev Are you seeking for a quick way to evaluate Oracle software? If so, why don’t you try Oracle VM VirtualBox templates providing a good way to familiarize yourself with new software stacks running within a virtual machine? Oracle VM VirtualBox templates represent pre-installed and pre-configured software images, which you can import into […]
Oracle
The Quickest Way To Get Started With Oracle Database
The Quickest Way To Get Started With Oracle Database By Yuli Vasiliev If you already have any experience with installing an Oracle database in your system, you know that it can be quite a time-consuming task that requires you to complete a number of steps, including pre-installation and post-configuration ones. This can be especially disappointing if you just want to […]
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 […]
Accessing Web Data With Oracle SQL
By Yuli Vasiliev Can you really access Web data from your database? If you’re an Oracle database user, it is much easier than you think. The ability to access data stored outside of the database is one of those things that make Oracle Database unequivocally best in class. No matter where the data you need is located. No matter in […]
Using JSON_TABLE To Shred JSON Into Relational Data
Using JSON_TABLE To Shred JSON Into Relational Data By Yuli Vasiliev Being less verbose than XML, JSON is becoming more and more popular as a data exchange format in Web services and Web applications today. Starting with release 12.1, Oracle Database supports JSON, letting you access JSON content stored either inside or outside of the database. The example provided in […]
Shredding XML Into Relational Rows
Shredding XML Into Relational Rows By Yuli Vasiliev This article reveals how you might use SQL/XML functions in your SQL statements to access XML data, shredding it into relational rows and then joining them with regular relational data stored in an Oracle database. In particular, it explains how you might use SQL/XML function XMLTable to derive relational data from […]
Oracle XQuery to Access XML/HTML Content From the Database
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 […]
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 […]