The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT status, domidx_opstatus
FROM sys.all_indexes
WHERE owner = 'RRS' and index_name = x_index_name;
-- Delete existing and Insert new metadata
Update_Index_Metadata(l_index_name);
-- Delete existing and Insert new metadata
Update_Index_Metadata(l_index_name);
-- Delete existing and Insert new metadata
Update_Index_Metadata(l_index_name);
-- Delete existing and Insert new metadata
Update_Index_Metadata(l_index_name);
PROCEDURE Update_Index_Metadata (
p_index_name IN VARCHAR2
)
IS
x_del_meta varchar2(255);
x_del_meta := 'Delete from user_sdo_geom_metadata
Where table_name = ''' || l_table_name ||
''' and column_name= ''GEOMETRY''';
x_ins_meta := 'INSERT INTO user_sdo_geom_metadata (
table_name, column_name, diminfo, srid ) VALUES (
'''|| l_table_name ||''', ''GEOMETRY'',
mdsys.sdo_dim_array(
mdsys.sdo_dim_element(''longitude'', -180, 180, 0.00005),
mdsys.sdo_dim_element(''latitude'', -90, 90, 0.00005)), 8307 )';
END Update_Index_Metadata;