Daily Archives Thursday, May 2008

new look for monthly archives


Free hash in Holland - and some fun consequences

I heard this story from a Dutch friend, and I’m sure a) he’s completely wrong and b) I’ve misunderstood everything he said. We must have been drunk both of us. With that in mind, here’s the story as I recall it….It’s legal to use hash in Holland. It’…

10.2.0.4/Unix

Unix users will enjoy this : 10.2.0.4 is available on Solaris and HPUX
patchset 6810189
Still waiting for AIX…

Select bottom rows

Today I answered a question on otn regarding order by.
Let’s build a different test case.
You have a view that contain an order by. You want to retrieve the last 5 records. However you do not have access to the sort column.
SYS@LSC01> GRANT CREATE VIEW TO USER_A IDENTIFIED BY A;

Grant succeeded.

SYS@LSC01> GRANT SELECT ON SCOTT.EMP [...]

More Web 2.0 Expo: Worth the Time Investment

So, two keynotes from last week’s Web 2.0 Expo are worth watching, if you have a block of time.
One is Clay Shirky’s keynote from Wednesday afternoon. His observations are keen, and his presentation is both funny and interesting, well worth the 16 odd minutes.
The other is Dan Lyons’ keynote from Friday, which I missed in [...]

CommunityOne 2008

Those of you looking to beat the Monday blues (this coming Monday) should come out to CommunityOne 2008 in San Francisco. I’ll be part of the Ruby panel that’s being chaired by Tim Bray. Should be a good event. Best part… IT’S FREE!!!
The Ruby panel I’m on will be joined by Mark [...]

A Few Linux Tips and Tricks

I feel I’ve neglected the “Linux” aspect of my blog, so here a few tips that I hope you find useful.
What port is the TNS Listener listening on?

sudo netstat -tlnp | grep tns
tcp 0 0 0.0.0.0:1521 [...]