Developers who are used to AutoNumber columns in MS Access or Identity columns in SQL Server often complain when they have to manually populate primary key columns using sequences. This type of functionality is easily implemented in Oracle using triggers.

(Marc L. Songini)Oracle Corp. this week plans to announce enhancements to its treasury management applications that are designed to give end users faster access to financial data plus beefed-up regulatory compliance tools.

(Joris Evers) Oracle Corp. has partnered with a small Canadian software company to allow users of its Oracle Collaboration Suite e-mail product to access their mail on BlackBerry handhelds.

(Anne-Birte Stensgaard) Oracle Corporation today announced that Oracle Identity Management and single sign on are helping organizations strengthen security, comply with regulatory requirements and reduce administrative costs, as they increase access to applications.

(James Thornton) The problem with using identity columns as primary keys for Web development is that identities are generated at the time of insert, and you can’t pull them into your application code prior to inserting the row. This means that a user could double click the submit button resulting in

Royal Auto Club (RAC), serving millions of motorists per year throughout the UK, operates under one of the most stringent service levels possible – they must respond to stranded motorists within a pre-determined time of the driver’s distress call. Since 1998, Quest Software’s SharePlex® for Oracle h

by Norman Spector – Here is a script which will dynamically generate code for fast copying of tables to another database or another account. It very useful for fast scalable refresh of presentation tables in data warehousing projects, where production tables are very bulky.

Corel Corporation has teamed with Oracle to build and deliver a complete solution to enable the creation, storage and delivery of XML content and SVG Smart Graphic applications. Demonstrated at Oracle World Paris this week, the solution integrates the Oracle Database 10g with Corel’s XML tools, Core

(Nathan Folkert)This document illustrates the basics of the JDBC (Java Database Connectivity) API (Application Program Interface). Here, you will learn to use the basic JDBC API to create tables, insert values, query tables, retrieve results, update tables, create prepared statements, perform transa

By Lisa Valentine – Have Oracle and PeopleSoft CRM applications both evolved to be so feature- and function-rich that it is difficult to differentiate the two? To a large extent, yes. “From a feature/function standpoint — when you add it all up — Oracle and PeopleSoft come across as fairly equal,”