DBASupportOracle Database 11g: Flashback Transaction Backout
Oracle Database 10g offered two new Flashback features that allowed an authorized user to see all versions of any changes made to one or more rows in a table. Database 11gR1 provides the ability to back out one or more independent or dependent transactions with Flashback Transaction Backout.
Multilingual linguistic searching and sorting in Oracle
How well do you know the sorting rules of your own language? Chances are, Oracle knows them much better than you, in addition to knowing all the rules for all of the languages Oracle supports. Take a tour through Oracle's multilingual linguistic searching and sorting features.
Sorting Strings in Oracle
Learn what Oracle has to offer with respect to searching and sorting, and especially so when it comes to linguistic sorting. You may not know this, but you do have some control over how sorts are performed within your database's character set and you can compare Apples to apples, as it turns out.
So what is an Oracle Nested Table?
James Koopmann takes some of the confusion out of Oracle nested tables with this step by step approach to create a table with a nested table.
Oracle Database 11g: Flashback Data Archives
Oracle Database 11gR1 offers an intriguing new Flashback feature - Flashback Data Archives - that allows an Oracle DBA to preserve a record of all changes to any table for a definite period of time.
Searching and Sorting Strings in Oracle
Steve Callan discusses what takes place inside the Oracle database when you're searching for something "LIKE" the value of interest. How does Oracle approach the problem of determining if the string 'ABCD' appears in the string 'ABCABDABCDAB' and if it does, how many times?
ADDM Enhancements in Oracle Database 11g
This article illustrates how Oracle Database 11gR1 has expanded ADDM to encompass Real Application Clusters (RAC) database tuning at the global level and provided the ability to filter out previously identified performance issues from any ADDM analysis report.
Successful Database Migration
One of the issues that companies are facing in their operations is database migration to new hardware, or a different operating system platform, or even a new database vendor. This article describes the overall process.
Hidden treasures in Oracle's STATSPACK utility
STATSPACK is still very much a viable option for monitoring and diagnosing database performance. Even though it seems as if AWR and ADDM have voted to send STATSPACK to Exile Island, treasures and rewards can still be found, but it's up to you to find them and make the most of what's available.
Intro to Oracle's Automatic Workload Repository (AWR)
Oracle's Automatic Workload Repository improves quite a lot on the previous statspack; it installs automatically, has some fairly reasonable default settings, and brings us Active Session History as well. Read on to learn more...
Oracle Database 11g: Adaptive Cursor Sharing
This article discusses a new Oracle Database 11gR1 feature - Adaptive Cursor Sharing - and illustrates how to use it in practical situations to limit hard parsing of SQL statements with bind variables while increasing the relative execution efficiency of those statements.
Oracle and backups in the Cloud
Last week Oracle and Amazon Web Services held a webinar to outline how Oracle works on Amazon's EC2, including database backups to the Cloud.
Oracle's Top 8 stories of 2008
Database in the cloud, database in a box, the ongoing battle with SAP and another major acquisition. The past year was anything but quiet for Oracle.
Oracle ADF Development Essentials
Learn basic best practices for building Oracle Application Development Framework (ADF)-based apps productively--using Subversion, Ant, JUnit, and Hudson. From Oracle ACE Director John Stegeman.
Oracle Extends Configuration Management Capabilities in Oracle Enterprise Manager
With this release, Oracle Configuration Management Pack, available for Oracle Database, Oracle Middleware and non-Oracle systems, adds comprehensive, continuous, real-time detection, validation and reporting of authorized and unauthorized configuration changes, across Oracle and non-Oracle environments.
ora2pg 4.10
Ora2Pg is a Perl module to export an Oracle database schema to a PostgreSQL compatible schema.
BIND VARIABLES
Handling nulls through the use of bind variables in pl/sql scripts is a tricky task. Here are some exmples to handle nulls.
BETWEEN VALUES
While using between operator, only values in ascending order are accepted. If values
in descending order are given, you get no rows. However, if you use >= and <= operators, you have the privilege to use the range of values either in ascending order or descending order.
