Oracle Scratchpad

August 19, 2008


Filed under: Infrastructure — Jonathan Lewis @ 11:10 am BST Aug 19,2008

I’ve just come back from a couple of weeks wind-surfing – so I’ve spent the last few days recovering from sundry injuries and catching up on email.

One of the emails raised a point about deterministic function which made me realise that I still had a few items that I had written for Howard Rogers’ Wiki (which he closed down some time in 2007) linked to from my website. So, to get back into the blogging habit, I’ve finally copied the backups to my website and, for a brief period only, have listed them below:


  1. Hi Sir Jonathan,
    I just got your book Practical Oracle 8i – at last!! We don’t have your book in our country because it would cause 4-5x the price if we would buy it. Anyways, been reading it for some weeks now, and it’s really a great book. Although it’s not for beginners I think like myself, but I’m trying to re-create the scenarios you discuss in it. Sorry if this is the wrong part to post this, just want to say Thank you so much again for the great topics you provide it really helps a lot =)

    Also, your book is published few years ago, but I see your samples (like the ticker/prices in IOT) are also being used in other books I’ve read recently.


    Comment by rhani — August 22, 2008 @ 3:47 pm BST Aug 22,2008 | Reply

  2. Rhani,

    Thanks for the comment. I think the book is still relevant after 8 years and three versions. It’s getting out of date in the detail, of course, but it’s surprising how many times it has the answers to questions that still appear frequently on the Oracle Forum and Newsgroups.

    When people stop buying it, I plan to ask AW if I can take the copyright back and publish it on my website under the Creative Commons agreement as James Morle did for his excellent “Scaling Oracle 8i”.

    I’m not surprised that other people have used the ticker/IOT example – it would be nice to think that they had been inspired by my teaching, but it’s really a fairly obvious example to pick for IOTs. (I think biologists would call it something like “convergent evolution”).

    Comment by Jonathan Lewis — September 7, 2008 @ 9:40 am BST Sep 7,2008 | Reply

  3. Hi Sir Jonathan,
    Thank you very much for having the time to reply. I don’t think your book will be outdated even if many versions would come out. The explanations we’re great. It point out (without paying that much attention on the version, as Tom puts it “Do NOT be fooled by the 8i in the title, really” ) the pros and cons of each features and how and when to use it; like those chapters about tables, indexes and partitioning. Really your book is a must have for all oracle developers/dbas. I still need to read and learn more on oracle before I will start reading your book on CBO which requires a lot of experience I think. Thank you very much again Sir.


    Comment by rhani — September 11, 2008 @ 8:09 pm BST Sep 11,2008 | Reply

  4. Downloading the Scaling Oracle 8i book from Scale Abilities. Thanks for the link.
    Here in India your book is not available. I have tried at almost all places big and small.

    You mentioned “When people stop buying it, I plan to ask AW if I can take the copyright back and publish it on my website under the Creative Commons agreement …”. Its a very generous thought. By Gods grace i can afford to buy it from Amazon. but am now wondering whether i put it off till you get it realeased with CC.

    Thanks for the Good work.

    Comment by Sunil Choudhary — November 11, 2008 @ 2:29 pm BST Nov 11,2008 | Reply

  5. […] There are lots more details and, for a little more information, you might want to look at a couple of the notes that I originally wrote for the Dizwell Knowledge Base on this and related topics. […]

    Pingback by Shared SQL « Oracle Scratchpad — March 5, 2011 @ 12:46 pm BST Mar 5,2011 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by