Database Management TechGuides
Switching Oracle Portal to a new database is easy
Rex Baldazo shares how easy it is to quickly move Oracle Portal to a new metadata database.
Tags: Databases, Database management
Set named restore points for easier flashback in Oracle
Bob Watkins explains that one huge benefit to restore points is that they eliminate the need to know an exact System Change Number.
Tags: Databases, Database management
Sending e-mail from an Oracle database
Learn how you can use the nice modern utl_mail package to send e-mail messages from your PL/SQL applications.
Tags: Databases, Database management
Six configuration management database pitfalls to avoid
How to significantly increase the likelihood of a successful configuration management database implementation.
Tags: Databases, Database management
Are you running out of memory?
Rex Baldazo looks at ORA-04030 errors and wonders why the database does not warn specifically about the swap space issue.
Tags: Databases, Database management
Navigating Oracle's public online documentation
Here's a quick guide to navigating Oracle's public online documentation library, which contains hundreds of books. Bob Watkins also offers a rundown of his favorite offerings in the collection.
Tags: Databases, Database management
Learning Oracle ADF: Master-detail forms
Rex Baldazo looks at the more common case for Oracle ADF, where there is a master-detail relationship.
Tags: Databases, Database management
Find sequence gaps using Oracle's analytic functions
Oracle's analytic functions provide a clean way to do gap checking. These functions allow you to see the value in an upcoming row or previous row, while still using the full set-oriented processing of SQL.
Tags: Databases, Database management
Learning Oracle ADF: Simple JSF data view/entry form
Rex Baldazo shares more his learning experience working with the Oracle Application Development Framework.
Tags: Databases, Database management
Learning Oracle ADF: Creating Java objects from database tables
Rex Baldazo dives into the wonders of Oracle Application Development Framework.
Tags: Databases, Database management
Practice using Oracle's Remote Diagnostic Agent before you need it
Although the DBA can resolve most problems that arise with Oracle databases, there are times when you need to file a Service Request (SR) with Oracle Support.
Tags: Databases, Database management
Avoiding errors in this procedural language
Oracle's PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. Here's how you can avoid TOO_MANY_ROWS errors.
Tags: Databases, Database management
Practice using Remote Diagnostic Agent before you need it
Although the DBA can resolve most problems that arise with Oracle databases, there are times when you need to file a Service Request with Oracle Support.
Tags: Databases, Database management
Compute the percentage of a total
Many reports include a percentage of the report total on each line, in addition to the detail data being reported.
Tags: Databases, Database management
How to copy Oracle's Automatic Storage Management files
Oracle's Automatic Storage Management (ASM) introduced in Oracle 10g, provides an alternative to raw disk devices for storing Oracle-related files.
Tags: Databases, Database management
A changing market greets Oracle 11g
The company ships its first database update in more than four years. Is it up to today's content challenge?
Tags: Databases, Database management
Multi-dimensional modeling in Oracle SQL
A spreadsheet is often used as an example of a relational table. Its rows and columns are similar to the rows and columns in a database table.
Tags: Databases, Database management
How to control null data in Oracle
NULL data, which is sometimes called "absent" data, can be difficult to work with in relational databases.
Tags: Databases, Database management
Explore Oracle 10g's updated sample schemas
Each new release of Oracle database brings with it new features to explore. It can be a challenge to create adequate sample tables to play with a given feature.
Tags: Databases, Database management
Avoid this symbol in Oracle passwords
Password complexity is one of many things that IT auditors examine to see whether a system is secure.
Tags: Databases, Database management
Play video
