(Peter Abrahams) In previous articles I have written about why XML will take over the world and I have no doubt that the trend will continue. The benefits to business and to IT are compelling, XML helps create more agile enterprises, brings business and IT closer together and makes everyone more pro
Author: SSWUG Research
CopySchema
(Christophe Marcel) CopySchema is a utility for copying all the data from one Oracle schema to another. Although similar to the exp/imp and bulk load utilities of Oracle, it has the advantage of offering a simple GUI interface and of handling changes to the schema. For example, if you are copyin
X Is for XQuery
(Jason Hunter) Query may cause one of the biggest changes to server-side programming since Java servlets. XQuery is a query language specification under development by the World Wide Web Consortium (W3C) that’s designed to query collections of XML data—not just XML files, but anything that can appea
Converting dates in character fields
(Kent Milligan) We have files that have dates in character fields in the format “mm/dd/yy”. The dates are stored in character fields with the ‘/’ included so they can be converted to tab delimited file with the CPYTOIMP command. Under V5R1, V5R2 the dates with slashes ‘/’ converted perfectly. Now un
INF: MDX: How to Test for the Top Most Level in a Hierarchy
When you traverse a dimension through a Multidimensional Expressions (MDX), you may have to determine if you are at the top most level of the hierarchy. This article shows you four MDX expressions that allow you to find out if you are at the top most level of the hierarchy.
Lady and the Tramp
(Edd Dumbill) This week’s XML Deviant is a tale of two specifications. One, a scruffy ragtag affair that barely seems to do the job. The other, a well-heeled, aristocratic sort of document, groomed for longevity. You know what’s coming next, of course. The tramp of which I speak, the unlikely RSS, g
Gathering Space Usage Statistics
(Gregory A. Larsen) As a DBA, you will need to perform a number of different tasks to keep your databases and servers up and running. One of those DBA tasks you will need to perform is disk space capacity planning. You need to make sure there is enough disk space, so when one of your databases n
Web Analytics Using Oracle Application Server Discoverer
(Timothy Cambier and Brian Carr) If you are responsible for managing your company’s website or administrating the web servers on which it reside, then you are most likely reporting site usage statistics to management. Analyzing the information found in the log files generated from your web serve
How to Misuse SQL’s FROM Clause
(Stéphane Faroult) FROM what? It may seem surprising to state it so, but the FROM clause of SQL statements seems to be one of the most often misused parts of SQL queries. Misused? How is that possible? We put into the FROM clause all the tables to join together in a query, don’t we? Well, well
What Color is Your Schema?
(Bogdan Blaszczak) There is no doubt that the World Wide Web Consortium (W3C) XML Schemas enjoy quite a success. They are used in many major software environments and are applied to many domains, from finance to the Search for Extra Terrestrial Intelligence (SETI).