SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …

23Nov/060

Oracle SQL: Summarize a calculated column (like a count(*) column) with ROLLUP


You have a simple sql statement like this:

select machine, count(*) as users
from v$session
group by machine

This query returns the session count on each machine:

MACHINE USERS
machine1 16
machine2 17
machine3 15
machine4 14

Tagged as: , , , , , , , , , , , , , Continue reading
2Nov/060

Wordpress PingPost plugin: Avoiding duplicate content


The PINGPOST plugin for Wordpress is absolutely great.
Just install it (simply copy one php page to your wordpress plugins directory) and set your options on the options dialogue in wordpress).
All done. It works perfectly. But there a problem exists when you've changed your Wordpress permalink structure.

Tagged as: , , , , , , , , , , , , Continue reading
   Older Entries »
Custom Search

Recent Posts

Tags

Abstract Als Amp Carpal Tunnel Syndrome Cast Application Chf Compendium Computer Mouse Der Schweiz Ein Fiat Fiat Ulysse Google Google Maps Hotels Ins Kriterien legoland Legoland Park Lt Mail Medical History Mit Nun oracle Oracle 7 Oracle Database Oracle Forms Oracle Sql Oracle Toad Peugeot Php Pl Sql Repetitive Strain Injury RSI Schweiz Solution Number Sql Code Sql Oracle Sql Statement Switzerland Toad Toad Oracle Wikipedia Wrist Pain

Recent Comments

Categories

Blogroll