(Clint Boulton) With interest in secure single sign-on services reaching new heights, Oracle and Novell unveiled new identity management products at the Burton Group Catalyst Conference in San Diego. Oracle revealed enhancements to its Oracle Identity Management (OIM) product, including securit

(Sanjay Ray) This tip was written for use with Oracle8i. This code tip demonstrates a technique to track changes occurring in the underlying database tables following a sequence of events in the front-end application. That is, the user keys in data through the application, or runs a process,and the

(Andrei Cioroianu) The JSP 2.0 Expression Language (EL) is a much-needed feature for Web developers who want to build scriptless JSP pages. It was designed as a part of the JSP Standard Tag Library (JSTL) 1.0, and then JavaServer Pages (JSP) 2.0 adopted and enhanced the EL. In its current form,

(Steven Feuerstein) Some of my past articles in Oracle Magazine have offered a variety of “big picture” best practices to help you write code properly. This article takes a different approach. It invites you to pay attention to seemingly minor details in the way you write IF statements, loops, and d

(Jayant Kulkarni) One of the key pieces of information needed in performance tuning under a Cost Based Optimizer (CBO) is to identify whether stats are run on all the tables, indexes, and their sub-objects (partitions and sub-partitions).

(Carol Palmer and Jim Stenoish) This Technical Note is the first in a series about improving SQL*Loader performance. It provides steps for tuning the SQL*Loader date cache to improve performance during direct path loads. But before we talk about tuning the date cache, let’s briefly overview SQL*Load

(Haidong Ji) Because Analysis Service is bundled with SQL Server for free, many companies built data warehouses and OLAP cubes on top of SQL Server. DBAs usually use DTS to get data from Oracle and dump it into SQL Server for DSS and OLAP analysis. When you are ready to do data transformation from

(Galina Petrenko) We sometimes have to store phone numbers in a system in alphabetical format. We can convert and format alphabetical phone numbers using the TRANSLATE function.

(Mark Gurry) Whenever you execute a SQL statement, a component of the database known as the optimizer must decide how best to access the data operated on by that statement. Oracle supports two optimizers: the rule-base optimizer (which was the original), and the cost-based optimizer.

(Debu Panda) Transactions are always a vital part of everybody’s life .. Transactions are involved when we withdraw some money using an ATM or buy a mocha from the Starbucks or shop at Amazon.com. However most java developers misunderstand transactions and its impact on performance and robustness of