Database Reference
In-Depth Information
Figure 22.9
Selecting Rows
from a Table and a
Synonym on That
Table.
--Select from the ARTISTS synonym
SELECT ARTIST_ID, NAME FROM MYARTISTS WHERE NAME LIKE '%u%';
As you can see, both queries return exactly the same results.
22.3
Metadata Views
This section simply describes metadata views applicable to sequences and
synonyms. Chapter 19 describes the basis and detail of Oracle Database
metadata views.
USER_SEQUENCES
. Current user sequence objects.
USER_SYNONYMS
. Private synonym details.
