(Steve Callan) Not all errors in Oracle are fatal, and that statement applies to data manipulation language statements as well. Even though an error in and of itself may be fatal, when handled properly it becomes benign. The question is this: how do you make an otherwise fatal error benign or harmle

(Rich Gibson) How we look at our data forms our view of the world. Until recently most of us have ignored location because we lacked the tools (or the ability to use those tools) needed to acquire, manage, and present the spatial component of our data. This means we have missed the geospatial compon

(Lewis R Cunningham) I’ve written about Open Source and Oracle in the past but thought I would remind everyone that open source is a good place to go for new tools. Instead of starting from scratch, it sometimes helps to see if someone has done something already. My philosophy is to not reinvent the

(Bob Watkins) Bulk binding in PL/SQL is an important technique for efficient processing of dynamic DML. Instead of looping within your program, and submitting one UPDATE statement with each iteration, you use the FORALL statement to submit a single UPDATE statement with bind variables in it. Collect

(James F. Koopmann) Often times a single search condition with a singe WHERE clause is not enough and we need to search on multiple conditions.

(David A. Kelly) Creating a data security strategy that fits your business is more than simply ensuring that basic access controls are defined or proper firewalls are in place. Having a comprehensive security plan means going beyond traditional security approaches to find flexible solutions that can

(Brian Peasland) How do you calculate the difference between two dates in hours? (R)

(Barbara Darrow) In its latest attempt to navigate the tricky waters of direct and indirect sales models, Oracle is experimenting with new All Partner Territories.

(Lewis R Cunningham) This tip will answer two questions I get very frequently. Definitely a FAQ. “How do I retrieve and use the VARCHAR2 index of an associative array?” and “How can I sort a PL/SQL table?” These questions pertain to PL/SQL functionality; not SQL functionality.

(James Koopmann) Take control of Oracle’s queue with a step by step approach to getting rid of those pesky DBMS_JOBs.