Static Data Dictionary Views, 57 of 452

ALL_OUTLINES

ALL_OUTLINES describes all stored outlines accessible to the current user.

USER_OUTLINES describes all stored outlines owned by the current user.

Column	Datatype	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.