SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 61

we are about to join two or more tables permanently but no, its
just you are querying data from two or more tables using of the
techniques that fall under the title called “Joins”.
Other Database Objects: Views, Indexes, Sequences etc.
Besides tables that we create within our schema, there are other
logical structures called database objects. One of those objects is
called a View. Like the name says, it's a view, a window through
which we can see only the data we need or in other words we can
create a view and grant users to view the information. While
creating the view we will include only the information that we
want others to have access.
Figure 2-19: Managing other database objects: Views, Indexes,
Sequences, Synonyms. Once you drop a VIEW, base tables and views
comprising the dropped view will not get deleted. For each index you
create Oracle creates an implicit table based on that particular column
in a manner that will help it in locating records easier. Sequences are
like auto-number objects. You can always get the next number and
insert it in any number data-type column, usually id kind of field e.g.
emp_id.