6.84 SDO_NET.IS_HIERARCHICAL
Format
SDO_NET.IS_HIERARCHICAL( network IN VARCHAR2 ) RETURN VARCHAR2;
Description
Returns the string TRUE
if the network has more than one level of hierarchy; returns the string FALSE
if the network does not have more than one level of hierarchy.
Usage Notes
For an explanation of network hierarchy, see Network Hierarchy.
Examples
The following example checks if the network named ROADS_NETWORK
has more than one level of hierarchy.
SELECT SDO_NET.IS_HIERARCHICAL('ROADS_NETWORK') FROM DUAL; SDO_NET.IS_HIERARCHICAL('ROADS_NETWORK') -------------------------------------------------------------------------------- TRUE
Parent topic: SDO_NET Package Subprograms