8.9 SDO_GEOR_ADMIN.listGeoRasterTables
Format
SDO_GEOR_ADMIN.listGeoRasterTables() RETURN SDO_STRING2_ARRAYSET;
Description
Lists the GeoRaster tables defined in the current schema.
Parameters
None.
Usage Notes
This function returns an array of comma-delimited list of GeoRaster tables. The list contains the following information:
-
Schema name (only if you are connected as a user with DBA role)
-
GeoRaster table name
If you execute this function as a user with DBA role, then the function lists the GeoRaster tables defined in all the schemas in the database. Otherwise, it only lists the GeoRaster tables defined in the current schema.
Examples
The following example lists the GeoRaster tables defined in the database. It assumes that you are connected as a user with DBA role.
SELECT * FROM THE (SELECT SDO_GEOR_ADMIN.listGeoRasterTables FROM DUAL); COLUMN_VALUE --------------------------------------------------------------------------------- SDO_STRING2_ARRAY('GEOR_TEST', 'TEST_TABLE1') SDO_STRING2_ARRAY('GEOR_TEST', 'TEST_TABLE2')
Parent topic: SDO_GEOR_ADMIN Package Reference