by Alan Kotok – The United States federal government's XML Work Group, a sub-committee of the Chief Information Officers Council (CIOC), drafted its first guidelines that spell out best practices for the use of XML in federal agencies. This document, which begun circulating in early draft form f
Author: SSWUG Research
Changing the DB Name and data file paths the safe and easy way
(Michael Ritacco) A common way to rename all the database and all data files is to rebuild the control file. This can be very labor intensive, however, and possibly dangerous if you have a large number of data files. You could make a mistake and lose a data file or two in the process because the dat
Encrypting a string to a varbinary(128)
By Eli Leiba – This code is useful when encrypting sensitive data (like passwords) into a varbinary. The PWDENCRYPT and PWDCOMPARE functions are used to encrypt and compare DATA passwords are not visible in anywhere in the database.
How to Install Oracle9i EE on Red Hat Linux 7.1 and 7.2
This article details how Werner Puschitz installed the Oracle9i (9.0.1) database on Red Hat 7.1 (kernel 2.4.2-2) and on Red Hat 7.2 (kernel 2.4.7-10).
IETF draft: "Registration of xmlns Media Feature Tag"
Simon St. Laurent has announced an updated IETF draft prescribing a MIME media feature tag for XML content, which indicates the relevant namespace or namespaces in the transmitted document.
Wiring the Collaborative Enterprise
by Stuart J. Johnston – Although e-business initiatives tend to focus on transaction systems, collaborative systems are based on people working together. See what industry insiders say is driving the development of a new breed of collaboration platforms and applications built around XML.
Favorites Service: Phase Two Software Test Plan
By Jan McCollum – This is a draft of the software testing plan for Phase Two of the Favorites Service sample XML Web Service application.
Database Development in SQLJ, Part I: An Overview of SQLJ
by Boris Milrud – Instead of porting code in time-consuming fashion from one database platform to another, and dealing with proprietary procedural languages, use SQLJ to write Oracle stored procedures with database-independent code that can be easily ported to other Java-enabled database platforms.
Which indexes require a re-build?
By Danny Mohar – This script is used to determine which indexes require a re-build to assist with system performance. A ratio of 10-20% deleted lf rows to lf rows may be candidates. The script will attempt the used of dynamic SQL to execute the DDL commands required to execute the analyze table comm
Manually Removing all Oracle Components on Windows NT/2000
This article describes the procedure how to manually perform the actions to create a “clean machine” on Microsoft Windows 95/98/NT/2000 and how to manually remove all Oracle components (e.g.: oracle RDBMS database server, IAS, OEM, client installations, etc) and services from your computer.