[Home] [Help]
[Dependency Information]
VIEW: MDSYS.ALL_SDO_THEMES
Object Details
Object Name: | ALL_SDO_THEMES |
Object Type: | VIEW |
Owner: | MDSYS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OWNER |
VARCHAR2 |
(32) |
Yes |
|
NAME |
VARCHAR2 |
(32) |
Yes |
|
DESCRIPTION |
VARCHAR2 |
(4000) |
|
|
BASE_TABLE |
VARCHAR2 |
(64) |
Yes |
|
GEOMETRY_COLUMN |
VARCHAR2 |
(2048) |
Yes |
|
STYLING_RULES |
CLOB |
(4000) |
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, NAME
, DESCRIPTION
, BASE_TABLE
, GEOMETRY_COLUMN
, STYLING_RULES
FROM MDSYS.ALL_SDO_THEMES;
Dependencies
[top of page]
MDSYS.ALL_SDO_THEMES references the following:
-
MDSYS
-
SDO_THEMES_TABLE
-
PUBLIC
-
ALL_OBJECT_TABLES
-
ALL_TABLES
-
ALL_VIEWS
-
SYS
-
GETLONG
MDSYS.ALL_SDO_THEMES is referenced by following:
-
PUBLIC
-
ALL_SDO_THEMES