(MS Sridhar) This tip will help you understand how to apply the mod function and use it to obtain even and odd records from columns in Oracle.

(Azim Fahmi) I need to create a 10 character alphanumeric sequence for a client. The sequence is to be static like this: a111a11a11a. If it’s a number, increment 1 until you reach 9, then move to the next column, if it’s a letter, increment 1 until z, then move to the next column. Can you suggest a

(Stephane Faroult and Peter Robson) Any SQL statement that we execute has to examine some amount of data before identifying a result set that must be either returned or changed. The way that we have to attack that data depends on the circumstances and conditions under which we have to fight the batt

DBAs are constantly challenged to increase database performance while keeping costs down. This short paper discusses Resource Mapping Methodology (RMM) which defines a systematic process for performing Wait-Event analysis to optimize database performance. It includes a brief overview of Ignite for O

(Michael Blaha) Referential integrity is a database constraint that ensures that references between data are indeed valid and intact. Referential integrity is a fundamental principle of database theory and arises from the notion that a database should not only store data, but should actively seek to

(David Baum) Oracle Magazine spoke with Laura Ramos, vice president of the Health Care and Life Sciences team at Forrester Research, to learn how developers make applications smarter with Semantic Web technology.

(Stacy Cowley) Oracle continued its buying streak by acquiring Demantra, a maker of supply-chain management and planning applications for the manufacturing industry

(Mark Rittman) Part of the Oracle Fusion Middleware family of products, Oracle XML Publisher 5.6.2 is a Java-based product that gives you the ability to define, publish, secure and schedule reports built using SQL and XML data sources. Originally developed as a technology within E-Business Suite, Or

(Bob Watkins) Since Oracle 8i, the database has had the capability to send Internet e-mail via the UTL_SMTP package. This supplied PL/SQL package implements the Simple Mail Transfer Protocol (SMTP) as defined by Internet Request for Comments (RFCs).

(Alex Keh) Oracle supports .NET developers in a variety of ways. Oracle Data Provider for .NET (ODP.NET) offers many features, including support for new Microsoft ADO.NET 2.0 features, such as factory classes. And as part of Oracle Database 10g Release 2, database change notification allows a .NET c