Describing a materialized view

You can get summary, detailed, and formatted information about a materialized view.

This task builds on the task that creates a materialized view named mv1.

  1. Get summary information about the materialized view named mv1.
    DESCRIBE mv1;
  2. Get detailed information about the materialized view named mv1.
    DESCRIBE EXTENDED mv1;
  3. Click Export Results to copy the information.
  4. Get formatting details about the materialized view named mv1.
    DESCRIBE FORMATTED mv1;
    For example, 14 of the 38 actual results are shown below: