O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix A. Companylink Table Reference

Considering the amount of work that we do in this book with our Companylink tables, it can be advantageous to have a place of reference to see the tables used in our fictitious Companylink application. This appendix details the tables, columns, and datatypes used as the basis for the Companylink application.

The Companylink data model

The next screenshot shows the tables that are included in the Companylink data model. The tables are created and populated by running the companylink_db.cmd Windows command file. This file calls the companylink_ddl.sql script that creates the table structures and the companylink_data.sql script that populates them with data. These are the base tables used for examples throughout ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required