Database Reference
In-Depth Information
Table 7.1
Pseudocolumns in Oracle Database. (continued)
XML
XMLDATA
Special holder for XML data to allow modifications
of storage parameters. XML will be covered in
detail in Chapter 17.
Flashback
VERSIONS_{…}
There are six different flashback version query
pseudocolumns. See Chapter 13.
OBJECT_ID
Column object identifier.
OBJECT_VALUE
System-generated column names.
That more or less covers any referential information on operators, condi-
tions, and pseudocolumns. The next chapter covers more detail using
SQL*Plus, particularly with respect to formatting. Further SQL*Plus output
formatting detail is essential to proper use and understanding of Oracle SQL.
