Oracle

Oracle Pro Members Standard Members

Reporting on Sparse Date Data

by

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

Using 11gR2’s DBFS Database File System

by

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

Proxy Authentication Via Roles

by

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

Assuming Another User’s Identity In Oracle Database

by

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

Running Oracle Database on Oracle VM VirtualBox

by

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

Using external tables to invoke Linux utilities and hold the data received

by

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

External Table as a Data Loading Tool

by

External Table as a Data Loading Tool By Yuli Vasiliev The external tables feature can be used as a data loading tool – a good alternative to SQL Loader. You can create the external table with the SQL CREATE TABLE…ORGANIZATION EXTERNAL statement. Before you can do that, though, you have to set up a directory where the external table 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

Using OWB to Handle Heterogeneous Data Sources

by

Using OWB to Handle Heterogeneous Data Sources By Yuli Vasiliev Being an Oracle database user, you may need, at some point, to access data stored in a remote non-Oracle database system. This is where Oracle Warehouse Builder (OWB) – a powerful data integration tool pre-installed with Oracle Database – will prove useful. Using Oracle Warehouse Builder, you can perform extract,...

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

Implementing Row-Level Security with VPD

by

Implementing Row-Level Security with VPD By Yuli Vasiliev Virtual Private Database is a useful Oracle Database 11g Enterprise Edition feature that allows you to implement row-level security, centralizing access security mechanisms within your Oracle database. This article provides a simple example of how you might apply row-level VPD to the employees table from the HR/HR demonstration schema. To follow the...

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

NULLs and Average

by

NULLs and Average Aggregate functions, such as MAX, MIN, AGR, and SUM ignore NULLs. That may be a problem if you want to aggregate all the rows, not just those with non-NULL values for the column of interest. To solve this problem, you can use the NVL function. Read on to learn how. For the article sample, you’ll need to...

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 … 4 5 6 7