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

MATERIALIZED VIEW: SCOTT.EMP_SNAPSHOT

Object Details
Object Name: EMP_SNAPSHOT
Object Type: MATERIALIZED VIEW
Owner: SCOTT
Subobject Name:
Status: VALID
M-View Details
Container: EMP_SNAPSHOT
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: IMMEDIATE
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

EMP

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
EMPNO NUMBER (4) Yes
ENAME VARCHAR2 (10)
JOB VARCHAR2 (9)
MGR NUMBER (4)
HIREDATE DATE

SAL NUMBER (7)
COMM NUMBER (7)
DEPTNO NUMBER (2)
Query Text

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


SELECT EMPNO
,      ENAME
,      JOB
,      MGR
,      HIREDATE
,      SAL
,      COMM
,      DEPTNO
FROM SCOTT.EMP_SNAPSHOT;

Dependencies

[top of page]

SCOTT.EMP_SNAPSHOT references the following:

SchemaSCOTT
TableEMP
TableEMP_SNAPSHOT

SCOTT.EMP_SNAPSHOT is not referenced by any database object