VIEW: MDSYS.ALL_GEOMETRY_COLUMNS

Source

View Text - Preformatted

select "F_TABLE_SCHEMA","F_TABLE_NAME","F_GEOMETRY_COLUMN","G_TABLE_SCHEMA","G_TABLE_NAME","STORAGE_TYPE","GEOMETRY_TYPE","COORD_DIMENSION","MAX_PPR","SRID" from OGIS_GEOMETRY_COLUMNS where
(exists (select table_name from all_tables
         where table_name=f_table_name and owner=f_table_schema)
 or
 exists (select view_name from all_views
         where view_name=f_table_name and owner=f_table_schema)
 or
 exists (select table_name from all_object_tables
         where table_name=f_table_name and owner=f_table_schema)
)
and
(exists (select table_name from all_tables
         where table_name=g_table_name and owner=g_table_schema)
 or
 exists (select view_name from all_views
         where view_name=g_table_name and owner=g_table_schema)
 or
 exists (select table_name from all_object_tables
         where table_name=g_table_name and owner=g_table_schema)
)

View Text - HTML Formatted

SELECT "F_TABLE_SCHEMA"
, "F_TABLE_NAME"
, "F_GEOMETRY_COLUMN"
, "G_TABLE_SCHEMA"
, "G_TABLE_NAME"
, "STORAGE_TYPE"
, "GEOMETRY_TYPE"
, "COORD_DIMENSION"
, "MAX_PPR"
, "SRID"
FROM OGIS_GEOMETRY_COLUMNS WHERE (EXISTS (SELECT TABLE_NAME
FROM ALL_TABLES
WHERE TABLE_NAME=F_TABLE_NAME
AND OWNER=F_TABLE_SCHEMA) OR EXISTS (SELECT VIEW_NAME
FROM ALL_VIEWS
WHERE VIEW_NAME=F_TABLE_NAME
AND OWNER=F_TABLE_SCHEMA) OR EXISTS (SELECT TABLE_NAME
FROM ALL_OBJECT_TABLES
WHERE TABLE_NAME=F_TABLE_NAME
AND OWNER=F_TABLE_SCHEMA) ) AND (EXISTS (SELECT TABLE_NAME
FROM ALL_TABLES
WHERE TABLE_NAME=G_TABLE_NAME
AND OWNER=G_TABLE_SCHEMA) OR EXISTS (SELECT VIEW_NAME
FROM ALL_VIEWS
WHERE VIEW_NAME=G_TABLE_NAME
AND OWNER=G_TABLE_SCHEMA) OR EXISTS (SELECT TABLE_NAME
FROM ALL_OBJECT_TABLES
WHERE TABLE_NAME=G_TABLE_NAME
AND OWNER=G_TABLE_SCHEMA) )