(Uche Ogbuji) When designing XML and Web services schemata you will often (and ideally) reuse data elements defined in pre-existing standards. When you do, it is extremely useful to include links to such standards, providing precise data dictionary references. In so doing, you make processing and ma
Other News
Oracle Tip: Automate Oracle utilities with Windows Script Host
With each new Windows OS release, the command prompt gets further away from the user. Oracle still ships most of its main server utilities as command-line utility programs, so it’s becoming increasingly difficult to perform simple tasks. (R)
Access Microsoft SQL Server 2000 using PHP
(Jean-Luc David) Web developers must constantly cope with the pitfalls of integrating multiple platforms and technologies to produce seamless software solutions. PHP is an easy-to-learn and powerful open source scripting language. Microsoft SQL Server is a robust database product which can handle te
Generate test data using SQL
(Alexander Kuznetsov) Whether you are prototyping to prove a concept, developing a new application from the ground up, or just studying SQL, you need test data to run your application against. This article discusses how to generate enough test data to be useful for testing with the expected dist
Deleting the top 10 rows in a table
(Craig Mullins) My requirement is to delete the top 10 rows of a particular table on DB2. My table and data are as follows. (R)
XML 1.1 and Namespaces 1.1 revealed
(Arnaud Le Hors) On February 4, 2004, the W3C issued, almost confidentially, a new recommendation called “Extensible Markup Language (XML) 1.1”. This specification defines a new version of the now-omnipresent XML format. Given the importance of XML, one might think this would have created a great de
Which DML’s are running? How much Rollback?
(Shawn Ellinger) Each transaction will be put in the v$transaction table. This query will give you which rollback segment they are using and how much. It will also show how much temp space they are using. If the column STATUS shows up "ACT" the statement is currently running, if it shows up "INA" th
How Many Seconds Have Elapsed?
(Mir Mirhashimaali) Here’s a function to calculate the number of seconds elapsed in a given period of time.
BUG: ‘Unable to import binding’ error message when you try to create an XML Web service proxy for the .NET Framework remoting service that contains Char data type members or Guid data type members
When you run the Web Services Description Language tool (Wsdl.exe) in Microsoft Visual Studio .NET to create an XML Web service proxy for the .NET Framework remoting service that contains either a Char data type member or a Guid data type member, you may receive an error message that is similar to t
Programmatically Save DTS Packages to Files
(graz) One of the things that has always bugged me about DTS is how difficult it was to transfer the DTS packages from SQL Server to structured storage (aka a file on the disk). In Yukon, DTS packages are always stored as files but in SQL Server 2000 they are stored in SQL Server by default. It’s po