ALL_OUTLINES

ALL_OUTLINES describes all stored outlines accessible to the current user.

Related Views

• DBA_OUTLINES describes all stored outlines in the database. This is the only one of the three views that displays the OWNER column.
• USER_OUTLINES describes all stored outlines owned by the current user.

  Column	Datatype	NULL	Description
  NAME	VARCHAR2(30)		User-specified or generated name of the stored outline. The name must be of a form that can be expressed in SQL.
  OWNER	VARCHAR2(30)		Name of the user who created the outline
  CATEGORY	VARCHAR2(30)		User-defined name of the category to which this outline belongs
  USED	VARCHAR2(9)		Whether the outline has ever been used (USED, UNUSED, or UNDEFINED)
  TIMESTAMP	DATE		Timestamp of outline creation
  VERSION	VARCHAR2(64)		Oracle version that created the outline
  SQL_TEXT	LONG		SQL text of the query, including any hints that were a part of the original statement. If bind variables are included, the variable names are stored as SQL text, not the values that are assigned to the variables.
  			Note: This field may contain sensitive information about your database or application. Therefore, use discretion when granting SELECT or VIEW object privileges on these views.