by Anunaya Shrivastava and Steve Bobrowski – In my experience working with legacy systems, tables often store redundant data due to limitations in the system’s data model. For example, consider a file in a legacy system that stores information about the collector’s call history associated with a par

This tip comes from Krishna Sarabu – The following script helps you to find out the current database’s operating system & its version using java stored function(s).

By Eric Yen – Oracle9i’s new list-partitioning feature lets you organize large data sets more naturally, usefully, and easily.So, let’s step through our examples and get going. You can simply read along, or—if you have Oracle9i up and running and your user account has Create Table privileges

By Boris Milrud – Oracle databases provide a powerful mechanism for enforcing business rules, called referential integrity (RI), which is implemented either via a declaration of foreign key (FK) constraints (“declarative RI”) or via triggers. It is almost impossible to find an Oracle database with n

By Gilles Briard – Oracle has made sure to adhere closely to ISO (International Standards Organization) standards regarding the Euro character, so Oracle customers can rest assured that database versions released since the standards were set (8.1 and above) can handle the Euro character properly. Ho

By Karen Porter – I have often needed to find a value held within a table when I don’t know what table or column_name would hold the value. For example, I recently needed to determine if an incorrect domain name had been populated into the database, but with Oracle’s tools, I wasn’t sure where the v

by Bill Pribyl – To help prepare a newcomer into the world of PL/SQL, I have collected some thoughts about the way that most new users seem to react to the language.

The new Oracle Certification Program for Oracle9i offers three distinct certification tiers that are built to fit the needs of both IT professionals as well as the organizations they serve. Each tier constitutes a benchmark of expertise that is industry-recognized and approved as applicable for spec

From SeachDatabase.com – IT-Director has put together a top five list of database stories from 2001. They include Larry Ellison’s offer to be your mailman, Oracle’s dissing of DB2, and Sybase’s optimistic view of its future.

by Donald Bales – The Java Database Connectivity (JDBC) API is a set of interfaces that allow a Java programmer to access a database. The interfaces are implemented by each vendor’s set of implementation classes. After several years of working with Oracle’s JDBC implementation, I’ve learned a number