Oracle Spatial is an integrated set of functions, data structures, and tables that aid in storing and retrieving spatial data. That data describes shapes and their geometric relationships in two-dimensional, three-dimensional, or four-dimensional space. (R)

Sometimes you need to update or insert into a view. But say your view has multiple tables like the outemp view: create or replace view outemp as select EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,dname from emp e ,dept d where d.deptno = e.deptno

(James Koopmann) In the first of this series we looked at how to determine if sessions were running SQL from the V$SESSION & V$SESS_IO views and then how to extract the particular SQL from the V$SQLAREA & V$SQL_TEXT views. This article will take us a bit further and look deeper into SQL statemen

(Caroline Kvitka) Imagine being able to locate an item at any point in the supply chain, from raw materials to end purchase. The potential is huge: no more inventory counts, no lost shipments, no more guessing how much inventory is on the shelves. Radio frequency identification (RFID) could make

(Steve Callan) In this third article about Oracle on Windows, we will take a look at the registry. Generally speaking, the registry is a database that stores information about the setup and configuration of a PC. If you are not a Windows administrator, and want to stay in the Oracle world, so to spe

(Richard Stroupe) Oracle provides a utility, called RapidWiz, to automate the 11i Apps installation process. RapidWiz prompts the user for specific locations of prerequisite software, as well as the locations to install the underlying components used by the E-business suite. All three tiers are inst

Oracle Database 10g, the foundation of Oracle Corp.’s long-awaited platform overhaul, emerged from eWEEK Labs’ tests with our Analyst’s Choice recommendation. Database 10g addresses the needs of organizations pressured to increase uptime while cutting database staff, and it will pique the interest o

(Robert Freeman) Welcome to Oracle Database 10g New Features! This chapter is the place to start in your effort to learn all about Oracle Database 10g. In this chapter, we will first look at the “Grid” and see what it is all about. Then we move on to explain how to upgrade to Oracle Database 10g. Th

(Sudhindra Chillarige) Everyone has a favorite script to find the active SQL statements. Here is one of mine. It builds the information using an anonymous PL/SQL block. It reads the information of active sessions from gv$session_wait and gv$session. (They have been made generic to support RAC in

(Peter Coffee) Running Oracle Corp.’s Database 10g on hardware ranging from high-end workstations to field workers’ laptop PCs, the Region 5 Superfund Division of the U.S. Environmental Protection Agency is integrating terabytes of images and measurements into efficient, comprehensive support tools