(Sam) We’re working on an XML import routine and needed to first validate the incoming documents against an XML Schema. Since I wasn’t able to find a working example on the web I pieced together this UDF from the many posts on the subject.
Other News
DB2 on Each Platform Differs
(Jim Wankowski) The days of managing databases on one platform have long gone. Although your manager may presume that managing DB2 on OS/390 is pretty much the same as on Unix or Windows, you know better. It is, however, possible to leverage your DB2 knowledge to make the leap to another platform.
Trust Networks in a Web Services World
(Paul Madsen) Networks are everywhere. The Web is a network of linked resources. The Internet is a network of routers. Markets are networks of economic actors connected by the transactions in which they engage. Underlying this last network of business entities is a trust network that connects compan
Improving PL/SQL performance by using collections
(Mark Rittman) recently looked at some code written in Oracle7-style PL/SQL, and compared it with what is considered best practice with Oracle8i and 9i. The more up-to-date code generally runs around 3-5 times faster than the old style code, and, as part of understanding where the changes to PL/SQL
Relational database market rebounds
(Robert Westervelt) The relational database software market grew by 5% last year, and IBM held onto its lead for the third consecutive year, according to a Gartner Inc. study released recently. (R)
Create a New XML File Using XmlDocument
This script shows how to create and XML file quickly and easily – the example shown produces what amounts to a file listing, but can be modified to produce other types of content as well.
You may not be able to connect to an instance of SQL Server that is configured to use the TCP/IP server network library on a computer that is running Windows XP Service Pack 2
You may not be able to connect to an instance of Microsoft SQL Server 7.0, to an instance of Microsoft SQL Server 2000, or to an instance of Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000), and you may receive one of the following error messages.
Find all numbers in a string
(MAK) This function finds all the numbers in a string. (script)
Connecting with Oracle: Accessing Oracle via Access and Excel
(Steve Callan) Connecting with Oracle can be quite a challenge for new users and DBA’s. Once you’ve learned the ins and outs of configuration files and Oracle Net, connecting via SQL*Plus or another Oracle application is a piece of cake. However, as a new Oracle DBA in a small to medium sized busine
Apple, Oracle Plan Database Road Show
(Blane Warrene) Recently, Apple posted information about an international “road show” designed to publicize Mac OS X Server’s compatibility with Oracle’s 10g database platform. The road show will feature executives from both Oracle and Apple and will run in five cities: London; Paris; Tokyo; Res