The following lines contain the word 'select', 'insert', 'update' or 'delete':
stmt := 'SELECT directory_path FROM all_directories
WHERE directory_name=''SDO_ROUTER_LOG_DIR''';
SELECT COUNT(*) INTO row_count
FROM all_users
WHERE username = UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema));
SELECT COUNT(*) INTO row_count
FROM all_directories
WHERE directory_name = 'SDO_ROUTER_LOG_DIR';
SELECT directory_path INTO directory_path
FROM all_directories
WHERE directory_name = 'SDO_ROUTER_LOG_DIR';
stmt := 'SELECT COUNT(*) FROM user_constraints WHERE CONSTRAINT_NAME = :name';
stmt := 'SELECT COUNT(*) FROM IND WHERE INDEX_NAME = :name';
md_stmt := 'SELECT COUNT(*) FROM USER_SDO_NETWORK_METADATA WHERE NETWORK = :name';
ud_stmt := 'SELECT COUNT(*) FROM USER_SDO_NETWORK_USER_DATA WHERE NETWORK = :name';
stmt := 'SELECT COUNT(*) FROM TAB WHERE TNAME = :name';
stmt := 'SELECT MIN(P_ID) FROM final_partition';
stmt := 'INSERT /*+ APPEND */ into ' ||
SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name) || ' (vertex_id,p_id,x,y) ' ||
' select vertex_id, (p_id-:min_pid+1),x,y from final_partition';
stmt := 'SELECT COUNT(*) FROM ' ||
SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(tab_name) || ' WHERE m < 0 ';
stmt := 'SELECT min(m) FROM (SELECT m FROM ' ||
SYS.DBMS_ASSERT.ENQUOTE_NAME(tab_name) ||
' WHERE m < 0 ORDER BY m DESC) ' || ' WHERE rownum <= :no ';
INSERT /*+ APPEND */ INTO partition_tmp_3 (vertex_id,p_id,x,y,m)
SELECT vertex_id,
mdsys.SDO_ROUTER_PARTITION.get_pid(
mdsys.SDO_ROUTER_PARTITION.adjust_m(part_m,0,m),part_counter),
x,y,mdsys.SDO_ROUTER_PARTITION.adjust_m(part_m,0,m)
FROM partition_tmp_2;
stmt := 'SELECT max(m) FROM (SELECT m FROM ' ||
SYS.DBMS_ASSERT.ENQUOTE_NAME(tab_name) ||
' WHERE m >= 0 ORDER BY m) ' || ' WHERE rownum <= :no ' ;
INSERT /*+ APPEND */ INTO partition_tmp_3 (vertex_id,p_id,x,y,m)
SELECT vertex_id,
mdsys.SDO_ROUTER_PARTITION.get_pid(
mdsys.SDO_ROUTER_PARTITION.adjust_m(0,part_m,m),part_counter),
x,y,mdsys.SDO_ROUTER_PARTITION.adjust_m(0,part_m,m)
FROM partition_tmp_2;
stmt := 'SELECT COUNT(*) FROM ' || partition_tmp_1;
stmt := 'SELECT AVG(x), AVG(y) from ' || SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(partition_tmp_1);
stmt := 'SELECT mdsys.SDO_ROUTER_PARTITION.min_eigenvector(
sum(power(x-:1,2)), sum(power(y-:2,2)),
sum((x-:3)*(y-:4))) FROM ' || partition_tmp_1;
stmt := 'SELECT AVG(:1*(x - :2) + :3*(y-:4)) FROM ' || partition_tmp_1;
stmt := 'INSERT /*+ APPEND */ into partition_tmp_2 (vertex_id,p_id,x,y,m)
SELECT vertex_id,p_id,x,y, (:1*(x - :2) + :3*(y-:4) - :5)
FROM ' || partition_tmp_1;
INSERT /*+ APPEND */ INTO partition_tmp_3 (vertex_id,p_id,x,y,m)
SELECT vertex_id,
mdsys.SDO_ROUTER_PARTITION.get_pid(m, part_counter),
x,y,m
FROM partition_tmp_2;
SELECT * FROM partition_tmp_3 WHERE p_id=' || part_counter;
SELECT * FROM partition_tmp_3 WHERE p_id=' || sdo_util.number_to_char(part_counter+1);
INSERT /*+ APPEND */ INTO final_partition (vertex_id,p_id,x,y)
SELECT vertex_id,p_id,x,y FROM partition_tmp_3;
stmt := 'SELECT MIN(p_id), MAX(p_id) FROM ' ||
SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);
stmt := 'SELECT COUNT(*) FROM ' ||
SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name) || ' WHERE p_id = :min_pid';
EXECUTE IMMEDIATE 'INSERT /*+ APPEND */ into node_part
SELECT n.node_id, n.geometry.sdo_point.x, n.geometry.sdo_point.y, 0, null, null
FROM node n';
ins_stmt := 'INSERT INTO restricted_edges VALUES ' ||
'(:eid, :div, :sx1, :sy1, :sx2, :sy2,:ex1, :ey1, :ex2, :ey2)';
OPEN p_cursor FOR 'SELECT t.edge_id, t.divider, t.geometry.sdo_ordinates' ||
' FROM edge t WHERE t.edge_id in ' ||
'(SELECT edge_id FROM EDGE WHERE start_node_id IN (SELECT node_id FROM restricted_nodes) UNION' ||
' SELECT edge_id FROM EDGE WHERE end_node_id IN (SELECT node_id FROM restricted_nodes))';
EXECUTE IMMEDIATE 'INSERT /*+ APPEND */ INTO restricted_nodes
SELECT vertex_id, inedges, outedges FROM NODE_PART where vertex_id IN
(SELECT source_id FROM edge_part WHERE divider IN (''1'', ''A'') union
SELECT target_id FROM edge_part WHERE divider IN (''2'', ''A''))';
PROCEDURE update_node_part_edge_arrays
IS
TYPE CURSOR_TYPE IS REF CURSOR;
OPEN n_cursor FOR 'SELECT vertex_id FROM node_part where vertex_id>0';
OPEN e_cursor for 'select edge_id from edge_part where source_id=:id' using n_id;
OPEN e_cursor for 'select edge_id from edge_part where target_id=:id' using n_id;
stmt := 'INSERT INTO edge_array_tmp VALUES (:node_id, :outedges, :inedges)';
SELECT n.vertex_id, n.x, n.y, n.p_id, e.outedges, e.inedges
FROM node_part n, edge_array_tmp e
WHERE n.vertex_id=e.vertex_id';
END update_node_part_edge_arrays;
EXECUTE IMMEDIATE 'INSERT /*+ APPEND */ INTO edge_part
SELECT edge_id, start_node_id, end_node_id,
(SELECT p_id FROM node_part WHERE vertex_id = start_node_id),
(SELECT p_id FROM node_part WHERE vertex_id = end_node_id),
func_class, length, speed_limit, divider, null
FROM edge';
update_node_part_edge_arrays;
SELECT nt.node_id, nt.geometry, np.p_id partition_id
FROM node_tmp nt, node_part np
WHERE nt.node_id = np.vertex_id';
EXECUTE IMMEDIATE 'UPDATE edge
SET partition_id = (SELECT p_id from node_part
WHERE vertex_id = start_node_id)';
EXECUTE IMMEDIATE 'INSERT /*+APPEND */ into super_node_ids
(SELECT source_id FROM edge_part WHERE func_class = 1 or func_class=2
UNION
SELECT target_id FROM edge_part WHERE func_class = 1 or func_class=2)';
EXECUTE IMMEDIATE 'INSERT /*+APPEND */ into super_edge_ids
SELECT edge_id FROM edge_part WHERE func_class =1 or func_class = 2';
stmt := 'SELECT username FROM user_users';
name_query := 'SELECT t.name,t.geometry.sdo_ordinates FROM edge t WHERE t.edge_id = :1';
sign_query := 'SELECT to_edge_id, ' ||
'ramp || '':'' || exit || '':'' || toward '||
'FROM sign_post ' ||
'WHERE from_edge_id = :1';
'select t.geometry.sdo_ordinates from edge t ' ||
'where edge_id=:i'
INTO coords USING edge_ids(i);
stmt := 'SELECT COUNT(*) FROM SDO_ROUTER_DATA_VERSION';
stmt := 'SELECT data_version FROM SDO_ROUTER_DATA_VERSION';
delete_router_network(log_file_name, l_network_name, FALSE);
stmt := 'SELECT COLUMN_EXPRESSION FROM USER_IND_EXPRESSIONS WHERE INDEX_NAME = :name';
' as select n.node_id node_id,
n.geometry geometry,
n.geometry.sdo_point.x x,
n.geometry.sdo_point.y y
from NODE n';
' as select edge_id link_id,
start_node_id start_node_id,
end_node_id end_node_id,
elocation_edge_link_level(FUNC_CLASS) link_level,
length length,
speed_limit s,
func_class f,
geometry geometry,
name name,
divider divider
from EDGE';
' as select node_id node_id,
partition_id partition_id,
1 link_level
from NODE';
' as select link_level link_level,
a.partition_id partition_id,
subnetwork blob,
num_nodes num_inodes,
num_outgoing_boundary_edges+num_incoming_boundary_edges num_enodes,
num_non_boundary_edges num_ilinks,
num_outgoing_boundary_edges+num_incoming_boundary_edges num_elinks,
num_incoming_boundary_edges num_inlinks,
num_outgoing_boundary_edges num_outlinks, ' ||
SYS.DBMS_ASSERT.ENQUOTE_LITERAL('Y') || ' user_data_included
from
(select 1 link_level, partition_id partition_id
from PARTITION
where partition_id > 0
union all
select 2 link_level, partition_id partition_id
from PARTITION
where partition_id = 0) a,
PARTITION b
where a.partition_id = b.partition_id';
stmt := 'insert into USER_SDO_NETWORK_METADATA
(network,
network_category,
geometry_type,
node_table_name,
node_geom_column,
link_table_name,
link_geom_column,
link_cost_column,
link_direction,
partition_table_name,
partition_blob_table_name,
user_defined_data)
values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)';
stmt := 'insert into user_sdo_network_user_data
(network, table_type, data_name,data_type)
values (:1, :2, :3, :4)';
stmt := 'insert into user_sdo_network_user_data
(network, table_type, data_name, data_type)
values (:1, :2, :3, :4)';
stmt := 'insert into user_sdo_network_user_data
(network, table_type, data_name, data_type)
values (:1, :2, :3, :4)';
stmt := 'insert into user_sdo_network_user_data
(network, table_type, data_name, data_type)
values (:1, :2, :3, :4)';
PROCEDURE delete_router_network(log_file_name IN VARCHAR2 := 'sdo_router_partition.log',
network_name IN VARCHAR2 := 'ROUTER_NETWORK',
log_delete IN BOOLEAN := TRUE)
IS
full_file_name VARCHAR2(256);
log_message('ERROR: network delete failed, ' || l_network_name || ' network not found');
raise_application_error(-20020, 'Network delete failed, ' || l_network_name || ' network not found');
IF (log_delete) THEN
log_message('INFO: deleting the Routeserver network: ' || l_network_name);
stmt := 'select node_table_name, link_table_name,
partition_table_name, partition_blob_table_name
from USER_SDO_NETWORK_METADATA
where NETWORK = :name';
stmt := 'delete from USER_SDO_NETWORK_METADATA where NETWORK = :name';
stmt := 'delete from USER_SDO_NETWORK_USER_DATA where NETWORK = :name';
stmt := 'SELECT username FROM user_users';
stmt := 'SELECT MAX(PARTITION_ID) FROM PARTITION';
stmt := 'SELECT MAX(PARTITION_ID) FROM PARTITION';
SELECT r.edge_id, partition_id, maintype, subtype, value
FROM edge e, router_transport r
WHERE e.edge_id=r.edge_id';
stmt := 'INSERT /*+ APPEND */ INTO partitioned_router_transport
SELECT edge_id, 0, maintype, subtype, value
FROM router_transport
WHERE edge_id IN
(SELECT edge_id FROM edge WHERE func_class=1 OR func_class=2)';
stmt := 'SELECT MAX(PARTITION_ID) FROM ROUTER_TRUCKING_DATA';
SELECT nav_strand_id, seq_num, link_id, node_id, partition_id
FROM edge, router_nav_strand
WHERE edge_id=link_id';
stmt := 'INSERT /*+ APPEND */ INTO partitioned_router_nav_strand
SELECT nav_strand_id, seq_num, link_id, node_id, 0
FROM router_nav_strand
WHERE link_id IN
(SELECT edge_id FROM edge WHERE func_class=1 OR func_class=2)';
SELECT nav_strand_id, max(seq_num)
FROM router_nav_strand GROUP BY nav_strand_id';
stmt := 'SELECT MAX(PARTITION_ID) FROM ROUTER_TURN_RESTRICTION_DATA';