4.38 SDO_TOPO_MAP.LIST_TOPO_MAPS
Format
SDO_TOPO_MAP.LIST_TOPO_MAPS() RETURN VARCHAR2;
Description
Returns a comma-delimited list of entries for each TopoMap object currently active in the session, or an empty string if there are no currently active TopoMap objects.
Parameters
None.
Usage Notes
Each entry in the comma-delimited list contains the following information: the name of the TopoMap object, the name of the topology associated with the TopoMap object, and either updatable
if the TopoMap object can be updated (that is, edited) or read-only
if the TopoMap object cannot be updated.
For more information about TopoMap objects, including updatable and read-only status, see TopoMap Objects.
To remove a TopoMap object from the session, use the SDO_TOPO_MAP.DROP_TOPO_MAP procedure.
Examples
The following example lists the Topomap object name, topology name, and whether the object is updatable or read-only for each TopoMap object currently active in the session. (The example refers to definitions and data from Topology Built from Topology Data.)
SELECT SDO_TOPO_MAP.LIST_TOPO_MAPS FROM DUAL; LIST_TOPO_MAPS -------------------------------------------------------------------------------- (CITY_DATA_TOPOMAP, CITY_DATA, updatable)
Parent topic: SDO_TOPO_MAP Package Subprograms