(Lewis R Cunningham) I’ve written some in the past about Oracle and XML. A couple of days ago, some coworkers had a requirement and I created a simple example to show them one possible solution. I thought I would share that here.
Other News
Understand Oracle 10g’s new Hierarchical Query options
(Scott Stephens) Oracle 10g adds new pseudo columns to the SQL Hierarchical Queries that use START WITH . . . CONNECT BY . . . clauses. For more than a decade, Oracle SQL has had the ability to cause a query to follow a hierarchical relationship. For instance, you could specify a starting condition
Domain Objects Persistence Pattern for .NET
(Iqbal M. Khan) Domain objects in an application represent the core data and business validation rules relating to it. And, domain objects are usually central to the entire application and used by most subsystems. Therefore, their good design is critical for a good application design that is robust,
Other config parameters that you hopefully never touch
(Chris Eaton) Now on to the second half of the database manager configuration parameters that I suspect you won’t touch. The good news is that with each release of DB2 there are more configuration parameters that become automatic so that you don’t need to touch them. Here are more database manag
Inserting specific values into an identity column with SQL
(Arthur Fuller) Despite your numerous explanations about the value of identity columns and the usefulness of their arbitrary values, some of your coworkers insist upon sequential PKs within a given table. Then, when invoice numbers are missing, they panic, fearing litigation, fraud, or worse.
Stored procedures generator
(KOMTEL_NET) The most often job we have to do during writing queries are the basic stored procedures for manipulating datas on existing tables of database. It is perhaps the most thing for hesitate and make of syntax errors. Project developed helps avoiding things mentioned, you just will fill requi
Semantic search in WebSphere Information Integrator OmniFind Edition: The case for semantic search
(Thomas Hampp and Alexander Lang) Been searching for that customer phone number over and over again in your emails, but queries like “phone number” did not work? If so, semantic search would have made your life easier. Semantic search is a new search paradigm that overcomes the limitations of standa
FIX: A trace file may be reported as corrupted and contains a 128 KB region of zeros in SQL Server 2000
In Microsoft SQL Server 2000, when you open a server-generated trace file in SQL Profiler or when you read the trace file by using the fn_trace_gettable function, the trace file may be reported as corrupted. If you examine the file by using a hexadecimal editor, the section that was read when the er
Caching Made Simple – A Practical Birdseye Overview
(Michael Libby) One web accelerator stands alone offering better performance than any other: caching. This article is the first in a series created to show you how to leverage caching to boost your application performance! Other articles in this series will show the basics in overcoming caching limi
SQL Server 2005 XQuery and XML-DML – Part 1
(Alex Homer) Ever since the mid 90’s, as XML has evolved to become the optimum way to share, transport and persist data, developers have sought efficient ways to store, manipulate and generally take advantage of its capabilities. Increasingly fast and easy-to-use XML parsers have been developed,