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 ...