Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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(30)   Owner of the task
TASK_ID NUMBER NOT NULL Unique identifier of the task
TASK_NAME VARCHAR2(30)   Name of the task
DESCRIPTION VARCHAR2(256)   User-supplied description of the task
ADVISOR_NAME VARCHAR2(30)   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(30)   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)