APPENDIXSetting Up and Some Scripts

In this appendix you will find two things:

1. A setup script for the BIG_TABLE used in many of the examples in this book.

2. A series of scripts I use every day and have used heavily during the course of writing this book.

The BIG_TABLE setup script is one I use whenever I get a new “test database” to generate a table with lots of rows to test with. The SCOTT/TIGER EMP and DEPT only go so far after all. You have seen this table used throughout the book, here you will see how I generate it.

After that, I have four scripts that I use frequently along with detailed explanations of exactly what they do, how they do it, and how to use them. I hope you find them as useful as I do.

Setting Up BIG_TABLE

For examples ...

Get Effective Oracle by Design now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.