(Amit Zhankar) This tip selects a column from a table, weeds out the numeric characters, and returns the alphabetical characters.

(Scott Stephens) As applications become more and more complex, supporting business rules with triggers becomes more difficult. Triggers are useful for a wide range of applications, such as auditing, complex data validation, snapshots and data generation.

(Jim Czuprynski) Oracle 10g’s new DBMS_SCHEDULER package offers significant advanced features over its predecessor, DBMS_JOB, that any reasonably skilled Oracle DBA can use to insure that sufficient resources will always be available for processing complex business requirements. This article – the f

(Steve Callan) Let me start with a bad news/good news situation. The bad news: as far as job searches are concerned, it is becoming readily apparent that knowing only Oracle is not good enough anymore. Personally, I have taken major hits for not knowing SQL Server and have heard some static about DB

(Cassio Ferrari) For many years, we had problems in our production databases: tables would be dropped or truncated accidentally, or someone would create undesired objects. Also, we sometimes needed to do maintenance and we don’t want unauthorized users to change something in the database. To fix

(Rich Schwerin) Few, if any, of today’s business applications work in isolation. From the moment a sales rep engages a customer to the moment the account is paid and the order fulfilled, numerous heterogeneous applications and services combine behind the scenes to create business processes. Integrat

(Anthony Molinaro) One of the great new features of Oracle’s flagship database software, Oracle Database 10g, is its new MODEL clause, which you can use in SELECT statements. In this article we’ll look at some examples of the MODEL clause in action, and show how you can use MODEL to manipulate your

This year Oracle has combined two premier conferences, its business applications conference – Oracle AppsWorld – and its technology conference – OracleWorld – into one information-packed event you can’t afford to miss. Consolidating the conferences gives Oracle a single venue to present a comple

James De Carli and Rama Ramachandran) Unlike SQL Server, PL/SQL does not allow us to execute a SELECT statement within a stored procedure without a corresponding INTO statement. This means we cannot easily return a recordset back to the calling client whether it is an ASP script or another PL/SQ

This document demonstrates how to execute a database stored procedure, multiple times in a single database round trip, using the "Array Binding" feature of ODP.NET. The "Array Binding" feature, whose usage is specified by the ArrayBindCount property of OracleCommand, allows each value in an arra