(Modified) Oracle’s Scott Schema tables

This is a modified version of Oracle’s Scott schema objects that I use at work to test out small scenarios and test cases. The only changes to the original schema are that the necessary foreign key constraints have been added and all the object names start with “scott_” .The object name changes was necessary because I have both emp and dept tables in my current development schema which have actual application data.

You can find the actual table creation and insert statements at here

I will use this as a reference as needed in my future posts.

Cheers..
Rajesh.