Dev Corner

This tutorial shows how to select random row from IBM DB2 table. Read the rest of this entry »

Here is a SQL query that selects a random row from a Microsoft SQL Server table. Read the rest of this entry »

The following tutorial shows how to retrieve random record from MySQL database table. Read the rest of this entry »

Shortcodes are very effective way to include dynamic content into your posting. This tutorial will guide you through the process of creating your own shortcode. Just in few easy steps. Read the rest of this entry »

You can use the following SQL to select random record from a PostreSQL table. Read the rest of this entry »

There are lots of ways to select a random record or row from Oracle database table. Here is an example SQL statement. Read the rest of this entry »

This tutorial shows how to retrieve tags associated with WordPress post. You can retrieve tags for the current post or any other post. Read the rest of this entry »

You have nice WordPress blog set up and running. You want to make your site more attractive and professional by adding images to post excerpts displayed on your WordPress blog’s home page. This tutorial shows you how you can easily add post thumbnails to your homepage. Read the rest of this entry »

Problem:
Oracle tables are composed by extents. Extents are allocated from tablespace. You are given a table and you need to find in which tablespace it is stored. Read the rest of this entry »

Problem
You need to find when a PL/SQL procedure in an Oracle Database was updated. Read the rest of this entry »