Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Oracle database management, tutorials, scripts, coding, programming and tips for database administrators


Oracle's ASCIISTR() and Unicode Characters 07/12/2018

Although documented, the ASCIISTR() function may return 'interesting' results depending on the characters translated.  Read on to see what problems this can cause and a possible fix.

Using Oracle VM to Create Dev and Test Environments 06/25/2018

Using Oracle VM can be a fast and reliable way to create dev and test environments.  Read on to see how this can be done and how it can help migrate databases from other operating systems.

Creating an Oracle Patching Strategy 06/14/2018

Patching an Oracle installation can be interesting, especially if the patch needs to be backed out.  Read on to see how to create a process that preserves the original home.

Moving from Oracle Solaris to x86 05/29/2018

Since Solaris is soon to be unsupported the x86 platform may be a desirable choice.  Read on to see how to make the transition easier.

Oracle's Conventional Export (exp) May Cause Problems 05/14/2018

There may be some still using conventional export (exp); with Oracle 12 that may not be a good idea.  Read on to see why.

Pseudonymization Of Personal Data With Oracle 04/30/2018

The GDPR offers pseudonymization as a protection technique for personal data.  Read on to see what pseudonymization is and why it can be difficult to implement.

Does Your Oracle Table Really Need 255 or More Columns? 04/16/2018

Tables with 255 or more columns are not uncommon but Oracle introduces some interesting performance changes when dealing with them.  Read on to see what can happen for such tables.

Put Your Oracle Database In the Oracle Cloud 03/26/2018

It may no longer be true that an on-premises database is faster than one in the Cloud.  Oracle Cloud offerings are varied, so read on to see the available options to migrate to the cloud.

Backup to the Oracle Cloud 03/12/2018

With the explosion of cloud-based applications and database services, it might be wise to consider backing up local databases to the Oracle cloud.  Read on to see how to configure and execute such backups.

Oracle 12cR2 Upgrade and the Alert Log 02/26/2018

When upgrading an Oracle database to version you may find that scripts that scan the alert log stop working.  Read on to see why and how to address the issue.

Using Oracle's DBMS_PROFILER to tune PL/SQL 02/12/2018

Troubleshooting and tuning PL/SQL packages, procedures and functions can be a daunting task.  Read on to see how DBMS_PROFILER can make that job easier.

Oracle's Unified Auditing, Part II 01/29/2018

It may not be obvious, but some aspects of Unified Auditing only register audit trails for privileged users.  Read on to see which areas won't generate audit trails for conventional users.

Static Registration and the Oracle 12.2 Listener 01/11/2018

It may not be an easy switch to the listener if you have static registration configured.  Read on to see why.

Oracle's UNDO Tablespace and Autoextend 12/26/2017

Oracle's UNDO tablespace should be simple to manage but using Autoextend may not be the wisest choice.  Read on to see why.

Oracle's Bulk Collect and Limit Can Be A Problem 12/14/2017

Using Bulk Collect with the Limit clause may not process all of the data in the result set.  Read on to see why and how the problem can be avoided.

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM