Author: Yuli Vasiliev

Oracle Pro Members Standard Members

Transforming XML Data With XMLQuery in Oracle Database

Transforming XML Data With XMLQuery in Oracle Database By Yuli Vasiliev With a full-featured, native XQuery engine integrated with Oracle Database starting with 10g Release 2, you can accomplish various tasks involved in developing XML-enabled applications. With the help of Oracle XQuery you can construct XML data using SQL/XML functions such as XMLQuery and XMLTable, which provide a general interface…...

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

Data, Information, and Business Intelligence

Data, Information, and Business Intelligence By Yuli Vasiliev In a BI system, information you need can be derived from different data sources, and by different means. Once it’s been derived, however, it doesn’t matter where it has come from, thus allowing consumers concentrate on the business aspects rather than on the specifics of the internal structure. It’s important to realize,…...

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

Testing Oracle Database With Pre-built VM

Testing Oracle Database With Pre-built VM By Yuli Vasiliev You don’t have to prepare your system, download, and then install an Oracle database to be able to test it. You can significantly simplify the database installation process by using the pre-built Database App Development VM appliance running within Oracle VM VirtualBox. This appliance is available for download from the Pre-Built…...

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

Database Tables Holding Data in Oracle XML DB Repository

Database Tables Holding Data in Oracle XML DB Repository By Yuli Vasiliev This article illustrates how you might query the XMLType tables that hold the data available via Oracle XML DB Repository. In particular, you’ll look at how you might optimize XQuery queries that use functions fn:doc and fn:collection to reference the repository data, accessing the underlying storage tables directly…...

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

Reporting on Sparse Date Data

Reporting on Sparse Date Data By Yuli Vasiliev You may need to generate a row per hour within a certain day or generate a row per day within a certain date range. Often you need a report showing every date/time position within the entire range, regardless of whether there was an activity on a particular day or hour, or not…....

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 11gR2’s DBFS Database File System

Using 11gR2’s DBFS Database File System By Yuli Vasiliev The Oracle Database File System (DBFS) is an Oracle Database 11g feature providing a standard file system interface to store and access files within the database. The files are stored in a database table as SecureFiles LOBs. An important point to note here is that a DBFS file system is mounted…...

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

Proxy Authentication Via Roles

Proxy Authentication Via Roles By Yuli Vasiliev Proxy authentication via roles in Oracle Database gives you greater flexibility when you want to realize the principle of least privilege. You don’t grant privileges directly to users but to roles. Also, when connecting through another user, you’ll be able to enable only those roles that are needed to get the job done…....

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

Assuming Another User’s Identity In Oracle Database

Assuming Another User’s Identity In Oracle Database By Yuli Vasiliev Allowing a user to assume the identity of another user is an Oracle Database capability that allows you to give users privileges needed to get the job done without compromising the ability to trace what user performed an operation. This capability is known as proxy authentication and available in Oracle…...

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

Running Oracle Database on Oracle VM VirtualBox

Running Oracle Database on Oracle VM VirtualBox By Yuli Vasiliev This article covers how you might evaluate Oracle Database coming with the Database App Development VM appliance that installs on Oracle VM VirtualBox. This appliance includes Oracle Linux as the operating system, and a number of some other Oracle products pre-installed on it, including Oracle Database, allowing you to run…...

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 external tables to invoke Linux utilities and hold the data received

Using External Tables to Invoke Linux Utilities and Hold the Data Received By Yuli Vasiliev You might use external tables to query operating system data. As a preprocessor program to be used in your external table, you might create a shell script calling a Linux utility, such as ls, df, or ps. Moreover, you can pass arguments to the utility…...

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