(Steve Callan) So far, the trigger-happy DBA series has dealt with triggers related to Data Manipulation Language (DML) operations. As mentioned in the beginning of the series, another type of useful trigger is that of the system trigger. System triggers can be delineated into two categories: those

(Ilya Petrenko) In a previous tip, Fast Reset Sequences, I showed how to reset a sequence to MinValue with few calls to the data dictionary (SQL and PL/SQL implementations). The following script below is another approach to achiev the same result with even fewer calls. This technique is very useful

This document provides information that will help you resolve problems that occur when you run an application over the Web using Oracle9i Forms. It contains an outline of: the common causes for errors, the method you can use to verify your installation, and the tools and techniques provided to diagn

This article includes some great tips that can help in your development of applications with ColdFusion working against Oracle.

Oracle database backup and recovery is an inherently challenging process that becomes more difficult as databases grow in size and as increasing demands on database availability limit the time available to perform backups. Many organizations use custom-made scripts and manual backup methods to prote

PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other.

Tune in and explore the latest Oracle applications, watch insightful keynotes from top industry leaders, see product demos and more! Or watch keynotes from recent OracleWorld and AppsWorld Conferences.

(Robert Cordingley and Charlie Russel) Functions, like operators, act on data to return a result. However, unlike operators, functions can operate on zero, one, or more arguments. Of the built in SQL functions in Oracle 9i, there are single row functions, aggregate functions, analytical functions an

(Robert Westervelt) Aaron Newman is co-author of the Oracle Security Handbook and co-founder of New York-based Application Security Inc. Recently he talked with SearchDatabase.com about ways Oracle DBAs can defend themselves against trouble, and he warned that the biggest threats are often closer th

(Chris Lawson) Now that we have identified what the problem is, and have quantified it, we are ready to find the root cause. In order to accomplish this, the tuning specialist takes off the hat of the detective, and dons the hat of the pathologist. As the Oracle pathologist, the tuning specialist