Posts Tagged ‘alert log as an external table’

ROWNUM, Random updates and the Alert Log – A trip down Memory Lane

September 19, 2011

I met up with an old friend recently. Deb and I were in Toronto, hometown of a certain Simon Jennings.
Apart from being a top bloke, Simon was also my first mentor in the mysterious ways of SQL, a sort of Obi-Wan Kenobi to my Anakin Skywalker, but without the light-sabers.

Ah those heady days when the world was young…and I first discovered ROWNUM.
That pseudo column was one I used often when investigating the structure and data within tables. It was also, the source of some confusion.
(more…)


Follow

Get every new post delivered to your Inbox.

Join 56 other followers