Author: SSWUG Research

Community

SQL*Plus file finder

By Dusan Djuric – You are in a SQL*Plus (Windows) session. Somewhere on your machine is the one script you need, but where? The script name is something like my*query.sql, but you’re not sure. What do you do? Here’s a handy way find it fast.

Community

Oracle Replication Solutions

By Prakash – The management of copies of tables across a distributed database environment is replication. Replication may implicitly involve maintenance of all or some of the objects related to a table; e.g. Triggers, Indexes, Referential Integrities, and so on, so as to maintain database consistenc

Community

Reading Multiple Input Documents

by Bob DuCharme – When you run an XSLT processor, you tell it where to find the source tree document — probably in a disk file on a local or remote computer — and the stylesheet to apply to it. You can't tell the processor to apply the stylesheet to multiple input documents at once. The docume

Community

Using Oracle9i to Clean Up Indexes

By Joe Johnson – As a DBA, you undoubtedly understand the importance of proper indexing when tuning databases. New features in Oracle9i Database make it easier for you to monitor and manage your application’s index use. When you determine and confirm an index is not used by your application, you can

Community

XML meets national security

The Command, Control, Communications, and Computer (C4) Systems Directorate (J6) of the United States Defense Department's Joint Staff has issued a Request For Information (RFI)/Sources Sought Notice (SS) (solicitation number: DASW01-RFI 03-01-02) seeking to "find possible XML applications t