Well I finally managed to find a wordpress theme that I like , problem with the default one is that there’s only a small amount of viewable area and lots and lots of blue background areas. The new theme talian-10 is a three column theme and spreads throughout the span of the browser, also it gave me a chance to show more of my widgets. Sure you can add widgets to a theme with one sidebar column but the chances are users wont see them often. Since this is a blog most users just view the home page and move on , very few actually scroll down to see the rest of the posts , so very few actually see the widgets that are placed in the bottom of the sidebar. With this new theme viewers can see three widgets and the RSS subscriber as well , so now I can show recent entries and the recent comments to the user without him having to scroll down. ( you can see them right ? 
)
After installing the theme I started to play around with the code. The theme is written using PHP and modifying it is not that hard. I’m relatively new to PHP so it was a bit hard at first but you get used to it after playing around with it for a while. Well I didn’t learn much PHP but I did learn some MySql . Well if you haven’t heard about is Sun bought MySql for $1B.
Well here’s how I learned my MySql , I wanted to limit the number of recent comments and recent posts shown to 5. So I searched through the code and found an interesting thing. In MySql you can limit the number of rows returned by using the keywork LIMIT . Why cant the Oracle gurus think of implementing such a basic functionality is beyond me. So the following SQL query will retrieve only the first 10 records.
SELECT person_name FROM Person_Table LIMIT 10 — simple and cool
and if you want to say get rows between 5,10 that can also be done easily.
SELECT person_name FROM Person_Table LIMIT 5,5
I’m almost certain Oracle doesn’t have this functionality , but feel free to correct me if I’m wrong. Thats enough of MySql from me. Feel free to comment about the theme and if any of the widgets doesn’t work in your browser.
Like this post ? Don't miss another one , subscribe to my RSS feed. After all, more than a 60M people cant be wrong.
I think you can use the BETWEEN to fetch values in a range in Oracle and I think your right about the LIMIT thing , I dont think Oracle have that functionality.