Oracle SQL: the Essential Reference

1.3. Schema Objects

A schema object is a logical collection of data or other objects that are owned by a user and stored in the database. The following types of objects are considered schema objects:

• Clusters

• Database links

• Database triggers

• Dimensions

• External procedure libraries

• Index-organized tables

• Indexes

• Index types

• Materialized views/snapshots

• Materialized view logs/snapshot logs

• Nested table types

• Object types

• Operators

• Packages

• Sequences

• Stored functions

• Stored procedures

• Synonyms

• Tables

• Varying array types

• Views

• Database links

1.3.1. General Syntax

Generally, you reference schema objects in SQL statements using the following syntax:

schema.object_name.object_ part@dblink

These syntax elements have the following meaning:

schema

The name of the schema that owns the object. In Oracle, a schema corresponds one-to-one with a username; if the schema is omitted from a reference to a schema object, then the username that is currently logged in is used by default.

object_name

The name of the object being referenced, such as a table.

object_part

The name of a part of an object, for those schema objects that have a part, such as a column of a table.

dblink

The name of a database link referencing a remote database.

The syntax shown here, with a schema name followed by a period, then followed by an object name (for example, scott.emp) is commonly referred to as dot notation. Generally, if the schema. portion of a name is omitted; the schema of the user currently connected to the database will be ...