The Jonathan Lewis Pages

Practical Oracle 8i - Building Efficient Databases

Chapter 23: Number Crunching.


Addenda:

 


Errata:

On average, the time it usually takes me to find an error of some sort (sometimes just an error of omission or age) in an Oracle book is about 5 minutes. I found this to be true even of my own book. When I received the first copies fresh off the press, I flipped the book open, happened to hit this chapter, and read this SQL (p. 520):

	select {complicated expression} from tableX sample blocks (1);

If you have tried to use a variant of this SQL, you will have discovered that there is a spurious 's'. It should read:

	select {complicated expression} from tableX sample block (1);.

Back to Book Index