DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_ADVISOR_SQLW_TEMPLATES

Object Details
Object Name: CDB_ADVISOR_SQLW_TEMPLATES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
WORKLOAD_ID NUMBER
Yes
WORKLOAD_NAME VARCHAR2 (128)
DESCRIPTION VARCHAR2 (256)
CREATE_DATE DATE
Yes
MODIFY_DATE DATE
Yes
SOURCE VARCHAR2 (128)
READ_ONLY VARCHAR2 (5)
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      WORKLOAD_ID
,      WORKLOAD_NAME
,      DESCRIPTION
,      CREATE_DATE
,      MODIFY_DATE
,      SOURCE
,      READ_ONLY
,      CON_ID
FROM SYS.CDB_ADVISOR_SQLW_TEMPLATES;

Dependencies

[top of page]

SYS.CDB_ADVISOR_SQLW_TEMPLATES does not reference any database object

SYS.CDB_ADVISOR_SQLW_TEMPLATES is referenced by following:

SchemaPUBLIC
SynonymCDB_ADVISOR_SQLW_TEMPLATES