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

Object naming using synonyms

In our last chapter, we introduced the concept of a schema. We said that, in Oracle, no overt distinction is made between database users and object owners. When a database user creates database objects, that user owns those objects and they form the user's schema.

Schema naming

Throughout this book, we have only worked with objects that are within the Companylink schema. Thus, when we accessed these tables, we referred to them only by their name. Technically, however, we could reference them by their schema name as well as using dot-notation, as shown in the following example:

Schema naming

Prefixing the award table with companylink ...

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