DBA_ADVISOR_TEMPLATES

DBA_ADVISOR_TEMPLATES displays information about all templates in the database.

Related View

USER_ADVISOR_TEMPLATES displays information about the templates owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`		Owner of the task
`TASK_ID`	`NUMBER`	`NOT NULL`	Unique identifier of the task
`TASK_NAME`	`VARCHAR2(128)`		Name of the task
`DESCRIPTION`	`VARCHAR2(256)`		User-supplied description of the task
`ADVISOR_NAME`	`VARCHAR2(128)`		Advisor associated with the task
`CREATED`	`DATE`	`NOT NULL`	Creation date of the task
`LAST_MODIFIED`	`DATE`	`NOT NULL`	Date on which the task was last modified
`SOURCE`	`VARCHAR2(128)`		Optional task or template on which the template was based
`READ_ONLY`	`VARCHAR2(5)`		Indicates whether the task can be modified or deleted (`TRUE`) or not (`FALSE`)