SDO_CS.DELETE_ALL_EPSG_RULES( use_case IN VARCHAR2 DEFAULT NULL);
Deletes the basic set of EPSG rules to be applied in certain transformations.
Name of the use case to be associated with the application of the EPSG rules that are created. Must match the value that was used for the
use_case parameter value (either null or a specified value) when the SDO_CS.CREATE_OBVIOUS_EPSG_RULES procedure was called.
This procedure deletes the EPSG rules that were previously created by the SDO_CS.CREATE_OBVIOUS_EPSG_RULES procedure, and thus causes the default Spatial and Graph rules to be used in all cases. (See the Usage Notes for the SDO_CS.CREATE_OBVIOUS_EPSG_RULES procedure for more information.)
use_case is null, this procedure deletes all rows from the SDO_PREFERRED_OPS_SYSTEM table (see SDO_PREFERRED_OPS_SYSTEM Table). If
use_case is not null, this procedure deletes the rows associated with the specified use case from the SDO_PREFERRED_OPS_USER table (see SDO_PREFERRED_OPS_USER Table).
The following example deletes the basic set of EPSG rules to be applied in certain transformations.