SDO_GEOR_ADMIN.listGeoRasterColumns

Format

SDO_GEOR_ADMIN.listGeoRasterColumns(
         list_option VARCHAR2 DEFAULT NULL,
         table_name  VARCHAR2 DEFAULT NULL) 
RETURN SDO_STRING2_ARRAYSET;

Description

Lists the GeoRaster columns defined in the current schema or in all the schemas in the database.

Parameters

list_option

Type of GeoRaster columns to be listed.

The following STRING values are supported:

ALL: Specifies all types (REGISTERED or UNREGISTERED) of GeoRaster columns to be listed.
REGISTERED: Specifies only the REGISTERED GeoRaster columns to be listed.
UNREGISTERED: Specifies only the UNREGISTERED GeoRaster columns to be listed.
NULL (default): Specifies all types (REGISTERED or UNREGISTERED) of GeoRaster columns to be listed.

table_name

Name of the GeoRaster table.

The GeoRaster table name to be provided in the format, <schema_name>.<table_name>. If the <schema_name> is omitted, then the current user’s schema name is used.
If the table_name parameter is specified, only the GeoRaster columns in the specified table are listed. If this parameter is NULL, all the GeoRaster columns are listed.

Usage Notes

This function returns an array of comma-delimited list of GeoRaster columns with their registration status. The list contains the following information:

Schema name (only if you are connected as a user with DBA role)
GeoRaster table name
GeoRaster column name
Status: registered (a DML trigger is created for the GeoRaster column) or unregistered (no DML trigger is created for the GeoRaster column)

If you execute this function as a user with DBA role, then the function lists the GeoRaster columns defined in all the schemas in the database. Otherwise, it only lists the GeoRaster columns defined in the current schema.

Examples

The following example lists the GeoRaster columns defined in the current schema.

SELECT * FROM THE (SELECT SDO_GEOR_ADMIN.listGeoRasterColumns FROM DUAL);
 
COLUMN_VALUE
---------------------------------------------------------------------------------
SDO_STRING2_ARRAY('TEST_TABLE1', 'GEOR', 'registered')
SDO_STRING2_ARRAY('TEST_TABLE2', 'GEOR', 'registered')

The following example lists the unregistered GeoRaster columns in the current schema.

SELECT * FROM THE (SELECT SDO_GEOR_ADMIN.listGeoRasterColumns(‘unregistered’) FROM DUAL);
 
COLUMN_VALUE
---------------------------------------------------------------------------------
SDO_STRING2_ARRAY('TEST_TABLE1', 'GEOR1', 'unregistered')
SDO_STRING2_ARRAY('TEST_TABLE2', 'GEOR1', 'unregistered')