Free Newsletters:
Database Journal  
DBAnews  

DBASupport

 The Knowledge Center for Oracle Professionals

Search DBAsupport:
 
HOME 11g Central 10g Central 9i Central 8i Central Oracle News Scripts FAQ OCP Zone Resources Technical Docs Tools & Utilities Forums
internet.com


» HOME
» FEATURES
    11g Central
    10g Central
    9i Central
    8i Central
    Oracle News
» COMMUNITY
    Scripts
    Forums
    FAQ
    OCP Zone
» RESOURCES
    Resources
    Technical Docs
    Tools & Utilities
    Tech Jobs

Marketplace Partners
Become a Marketplace Partner


internet.commerce
Be a Commerce Partner












internet.com
Internet News
Internet Investing
Internet Technology
Windows Internet Tech.
Linux/Open Source
Web Developer
ECommerce/ Marketing
ISP Resources
ASP Resources
Wireless Internet
Downloads
Internet Resources
Internet Lists
International
EarthWeb
Career Resources

Search internet.com
Advertise
Corporate Info
Newsletters
E-mail Offers



 






DBASupport Oracle 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?

Joining Disparate Data in an Oracle Database
Learn how to join disparate or seemingly unrelated data using an Oracle-provided pseudo column to create the linkage.

Oracle Health Checks with Health Monitor; Using PL/SQL or ADR
Learn how to use health checks to stay on top of corruption in your Oracle database.

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.

Optimizer Hints in Oracle 11g (and hint overkill)
Oracle has many hints to choose from; know what they are and how they are different from one another before tossing them into production.

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's ADR Command Interpreter (ADRCI) Part 3
Oracle's new ADR with command interface shows promise for DBAs to quickly investigate diagnostic information.

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.

» More Features...

Receive articles via our XML/RSS feed




DBASupport News Keeping Active
Use Oracle Active Data Guard to set up a physical standby database for reporting and recovery.

Oracle New Year's resolutions, part 1: Advice for navigating 2009
With January 1 fast approaching, now is the time of year when people across the globe start thinking about their New Year's resolutions. The same, of course, is true of Oracle customers.

Linux Gets a Stocking Stuffer from Oracle
The open source code is supposed help ensure that data integrity is maintained.

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 database machine attracting interest but no sales
There has been lots of interest in Oracle's database machine, said CEO Larry Ellison, although he admiteed that the interest had not yet led to any sales.

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.

The top advice from Oracle experts in 2008
A look back at some of the most popular expert questions and answers of 2008.

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.

DreamCoder for Oracle 2009 beta available
Mentat Technologies announces the release of the first beta version of DreamCoder for Oracle 2009.

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.

IBM, Oracle, Red Hat Form Test Bed For Web Service Interoperability
With their impatience with standards bodies showing, IBM, Oracle, Ford Motor, Red Hat, Tibco Software, and other companies have banded together to form the Web Services Test Forum.

Programming Productively
Use Oracle SQL Developer to work efficiently with PL/SQL constructs.

Oracle Helps Linux Get Enhanced Data Integrity
Supporters say the new kernel technology could make Linux the safest OS for data. But will other vendors join in?

Oracle, Emulex Unite to Fight Data Corruption
A multi-vendor data integrity effort could soon help storage and application users avoid costly data corruption incidents.

» More News...

Receive news via our XML/RSS feed




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.

TEMP tablespace - Monitor and record use history
This script will monitor and record history for TEMP table space use. It will also send an alert if more than 80% used.

BEFORE APPEND
This script will insert a message into a specific line of multiple files.

DateAdd function Oracle
Get a new date based in interval parameter.

» More Scripts...



Latest Database Articles from DevX
An Introduction to the Yahoo! Query Language Platform
Find and Generate Missing Values in an Access Table
Adobe AIR: Running SQL Commands Against a Local Database
Flexible and Powerful Data Binding with WPF
SQL Techniques for Performing Operations on Matrices


Database Administration Forum Latest Forum Threads
Topic By Replies Updated
  How to restore a database via RMAN but different DB_NAME? ssmith 4 January 6th, 10:46 PM
  ora 27300 ora 27301 ora 27302 oraclevijay 0 January 6th, 08:39 PM
  Issue to use REPLACE or TRANSLATE function in SQL*LOADER control file traveller 0 January 6th, 04:58 PM
  OS image copy (windows) to move database and oracle binary (8, 9i) to another server xyz2000 0 January 6th, 11:46 AM


Database Development Forum Latest Forum Threads
Topic By Replies Updated
  operation would exceed the maximum number of opened files or LOBs giridharn 0 January 6th, 01:49 AM
  sql query sadha@dbsupport 4 January 5th, 08:46 AM
  is there any alternative solution for this?? rtnataraj 0 January 5th, 04:18 AM
  Query Help vloops 2 December 31st, 10:44 AM





internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info

Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers