Using where clause in hierarchical queries may be confusing. Oracle first evaluates the joins in the query if there are any. Then, next step, selects rows in hierarchical order. Finally, applies remaining where clause conditions.
Other News
Working with web services using the EXPath HTTP client
(James R. Fuller) EXPath is a community-driven effort whose goal is to define common extensions for XML technologies, making it easier for developers to create portable applications using well-defined function libraries.
LINQ to log files
(Jon Skeet) Many people hear “LINQ” and think “databases”. This is not surprising given the emphasis Microsoft has placed on LINQ to SQL and Entity Framework, but I believe that LINQ to Objects has had an incredibly powerful impact too.
A single procedure to ‘hang’ the database
(randomdba) I really enjoy it when people don’t understand the features they are using it makes life really interesting, automatic parallelism is a great new feature of 11.2 but we found a new and interesting way to break things.
Valentine’s Day: How to date with DB2…
(Henrik Loeser) Today is Valentine’s Day and according to Wikipedia an annual commemoration to “celebrating love and affection between intimate companions”. This sounds like the typical DBA and database system relationship to me.
The DB2Night Show #41: DB2’S GOT TALENT another success!
(Scott Hayes) Judge Susan Visser, IBM, wrote a terrific blog about our 2nd contestant search show. Rather than steal her thunder, we suggest you READ HER BLOG! 93% of our studio audience indicated that they learned something that will be helpful to them!
File Upload/Download to SQL Server using Dynamic Data Services
(Tristan Lim) Shows how to incorporate upload/download to SQL server function directly using Dynamic Data:
Using Deferred Objects In jQuery 1.5 To Normalize API Responses
(Ben Nadel) As many of you probably know, jQuery 1.5 was released at the end of January. A big part of this release was the addition of Deferred objects and a complete rewrite of the AJAX functionality which now relies heavily on deferred objects.
Comparing MySQL Statement-Based and Row-Based Replication
(Chris Schneider) There are many ways you can replicate MySQL data, whether it be a simple two-node cluster, chain or master/master. This article explains the two types of data replication (Statement-Based Replication and Row-Based Replication) available in MySQL.
Top 10 Transact-SQL Statements a SQL Server DBA Should Know
(Muthusamy Anantha Kumar) Microsoft SQL Server is a feature rich database management system product, with an enormous number of T-SQL commands. With each feature supporting its own list of commands, it can be difficult to remember them all.