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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
