Tag

I was trying to make a choice today between selecting MySQL and Oracle XE for a BI project. I didn't know the limitations off-hand and was surprised I had to start digging through Oracle docs to find it. Here they are for your convenience.

Recursive queries are something I have used many, many times over the years to build dynamic, n-tiered hierarchies. Oracle’s CONNECT BY PRIOR is awesome. Does anyone know if this is possible in SQL Server or MySQL? From what I understand, stored procedures would need to be...

We have a family tree. Some people have children, while others do not. We want to sort results by alphabetically listing individuals with children in an initial group, and then those without children in a second group -- also alphabetically. Let’s assume there is not an...

You lie in wait, looking for your prey, it approaches, and looks around. You spring the trap and find the spoils of war…the dreaded %20 Ok, maybe not all that exciting, but it brings up an important problem in data conversion and in application development projects. Namely...

The Task: Take and load, using MySQL, a flatfile of over 450 colums and over 145,000 rows of data and put it into a staging table. The Conditions: The data may not be altered prior to the staging load, or in the staging load. Only when the data is loaded from staging to the...