XML Feeds
Was reading through a listserver group that I am subscribed to, and a question prompted me to repost this information. It is in fact included in the Email Utility that I have here, but thought it worth posting on its own as well. I cannot remember where I found the original code of this file dump utility, however, originally it was accompanied by a dump_fixed routine as well. I later enhanced the overall into a single API call with additional features such as... more »
PermalinkPrime example showing benefits of Analytical Functions
On the topic of analytical functions, I will be the first to say that they are not my strength. However that said, reading one article after another I am increasingly aware of what I am missing. I stumbled upon an excellent article demonstrating significant performance gains across the board from timing to resource utilization, all due to the use of analytical functions. I encourage you take some time and review the posting. more »
IETester: Develop/test your site in IE 6, IE 7 and IE 8 RC1
When developing or testing your web application, you often have to support different browsers and versions. On Window machines testing for different versions of Firefox, Opera and Chrome is not a real problem as these browsers all allow you to install different versions on one machine. Only Internet Explorer (IE), is always a bit more difficult, because it?s integrated in the OS (Windows) of the machine. This mostly ends up installing multiple IE versions on multiple (virtual) machines, which is not a nice way of working when developing. Can we do this different and easier? more »
Virtual Columns in 11g
Oracle has supported stored expressions for many years, in views and function-based indexes. Most commonly, views enable us to store and modularise computations and expressions based on their underlying tables' columns. In more recent versions (since around the 8i timeframe), we have been able to index expressions using function-based indexes. Now, with the release of 11g, Oracle enables us to store expressions directly in the base tables themselves as virtual columns. more »
Count number of character occurences in a string
A question was posed on the listserver regarding the 'how' of identifying how many vowels are in a particular string of text. Not certain as to the purpose of same, however intresting nonetheless. For those on 10g+, use of the REGEXP% syntax comes into play. more »
Using Analytic Functions in Oracle
This article is just to show some quick yet simple examples of how to use analytic functions in ORACLE. Though It doesn't cover all the analytical functionsavailable, I am just focussing on trivial functions we use in daily sql queries and to understand the way analytics work for them. All the following examples are tested on ORACLE Version 10.2.0.3.0 more »
Identify missing dates in a table
You have a 100,000 row table with lots of data over the course of a year. You know that ideally you should have a number of transactions for every day of the year. However, you are not sure if you have any gaps of time. How can find the gaps of time ?Lots of ways to slice it, but here is how I would do it ... more »
Father of MySQL leaves Sun and starts up MariaDB Project
I recently read an article that the Author of MySQL, who was working for Sun, left the company due to a disagreement of where Sun was leading MySQL. I know this site is primarily geared towards Oracle, however it is DB related for certain, and interesting news to say the least. more »