(Jony Safi) This query lists information needed by a DBA to trace the use of the TEMP tablespace.

(Arup Nanda) John, the lead DBA at Acme Bank, is at the IT center of attention in a high-level company acquisition. Recently Acme Bank acquired another bank, taking over its entire technology infrastructure. One special area of interest is the other bank’s data warehouse database, which has been

(Robert Westervelt) The U.S. Marine Corps is giving its commanders the ability to more efficiently oversee deliveries of food, ammunition and other supplies to troops deployed abroad and stationed at home. The military branch is selecting Oracle Corp.’s E-Business Suite for its combat and logisti

(Brad Cowdrey) Part 5 will take an in-depth look at analytical ranking features, including ranking and hypothetical (what-if) ranking through examples including syntax and behavior. In addition, Part 5 will build on information and examples from the previous articles in the series. All of the ex

(Andrei Cioroianu) JavaServer Pages (JSP) and JSP Standard Tag Library (JSTL) provide many useful tags (also known as actions) for Web developers. In addition, JSP 2.0 has two APIs, called Classic Tags API and Simple Tags API, that allow you to build custom tags/actions. The former API was inherited

(Deepak Vohra) Maven is an open-source project development tool from the Apache Jakarta Project for building and managing Java projects; it integrates the capabilities of other open source development lifecycle tools such as Ant, Junit, and Jelly. A Maven project consists of a J2EE project file or a

(Philip Greenspun) A trigger is a fragment of code that you tell Oracle to run before or after a table is modified. A trigger has the power to –make sure that a column is filled in with default information –make sure that an audit row is inserted into another table –after finding that

he simplest form of program has some declarations followed by an executable section consisting of one or more of the SQL statements with which we are familiar. The major nuance is that the form of the SELECT statement is different from its SQL form. After the SELECT clause, we must have an INTO clau

(Steven Feuerstein) In recent years, dynamic SQL has become a much more common aspect of PL/SQL programming. Prior to the availability of Native Dynamic SQL (NDS) in Oracle8i, dynamic SQL was available in PL/SQL only through the DBMS_SQL package. Although very robust, DBMS_SQL was very difficult

In Microsoft SQL Server 2000 Reporting Services, you can build and deploy a report that uses data from an Oracle data source. This article describes how to configure and access an Oracle data source for a report that you develop and deploy by using Reporting Services. You can use an Oracle data