MDSYS.SDO_ROUTER_PARTITION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

    stmt := 'SELECT directory_path FROM all_directories
             WHERE directory_name=''SDO_ROUTER_LOG_DIR''';

Line: 90

  SELECT COUNT(*) INTO row_count
  FROM all_users
  WHERE username = UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema));

Line: 100

    SELECT COUNT(*) INTO row_count
    FROM all_directories
    WHERE directory_name = 'SDO_ROUTER_LOG_DIR';

Line: 111

    SELECT directory_path INTO directory_path
    FROM all_directories
    WHERE directory_name = 'SDO_ROUTER_LOG_DIR';

Line: 180

  stmt := 'SELECT COUNT(*) FROM user_constraints WHERE CONSTRAINT_NAME = :name';

Line: 198

  stmt := 'SELECT COUNT(*) FROM IND WHERE INDEX_NAME = :name';

Line: 217

  md_stmt := 'SELECT COUNT(*) FROM USER_SDO_NETWORK_METADATA WHERE NETWORK = :name';

Line: 220

    ud_stmt := 'SELECT COUNT(*) FROM USER_SDO_NETWORK_USER_DATA WHERE NETWORK = :name';

Line: 239

  stmt := 'SELECT COUNT(*) FROM TAB WHERE TNAME = :name';

Line: 324

  stmt := 'SELECT MIN(P_ID) FROM final_partition';

Line: 327

  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';

Line: 352

  stmt := 'SELECT COUNT(*) FROM ' ||
    SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(tab_name) || ' WHERE m < 0 ';

Line: 362

    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 ';

Line: 367

    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;

Line: 377

    stmt := 'SELECT max(m) FROM (SELECT m FROM ' ||
      SYS.DBMS_ASSERT.ENQUOTE_NAME(tab_name) ||
        ' WHERE m >= 0 ORDER BY m)  ' || ' WHERE rownum <= :no ' ;

Line: 382

    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;

Line: 422

  stmt := 'SELECT COUNT(*) FROM ' || partition_tmp_1;

Line: 433

  stmt := 'SELECT AVG(x), AVG(y) from ' || SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(partition_tmp_1);

Line: 436

  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;

Line: 441

  stmt := 'SELECT AVG(:1*(x - :2) + :3*(y-:4)) FROM ' || partition_tmp_1;

Line: 444

  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;

Line: 458

    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;

Line: 484

        SELECT * FROM partition_tmp_3 WHERE  p_id=' || part_counter;

Line: 494

      SELECT * FROM partition_tmp_3 WHERE p_id=' || sdo_util.number_to_char(part_counter+1);

Line: 499

    INSERT /*+ APPEND */ INTO final_partition (vertex_id,p_id,x,y)
     SELECT vertex_id,p_id,x,y FROM partition_tmp_3;

Line: 534

  stmt := 'SELECT MIN(p_id), MAX(p_id) FROM ' ||
    SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name);

Line: 538

  stmt := 'SELECT COUNT(*) FROM ' ||
    SYS.DBMS_ASSERT.ENQUOTE_NAME(p_tab_name) || ' WHERE p_id = :min_pid';

Line: 782

  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';

Line: 825

  ins_stmt := 'INSERT INTO restricted_edges VALUES ' ||
    '(:eid, :div, :sx1, :sy1, :sx2, :sy2,:ex1, :ey1, :ex2, :ey2)';

Line: 830

  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))';

Line: 874

  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''))';

Line: 883

PROCEDURE update_node_part_edge_arrays
IS
  TYPE CURSOR_TYPE IS REF CURSOR;

Line: 906

  OPEN n_cursor FOR 'SELECT vertex_id FROM node_part where vertex_id>0';

Line: 914

    OPEN e_cursor for 'select edge_id from edge_part where source_id=:id' using n_id;

Line: 927

    OPEN e_cursor for 'select edge_id from edge_part where target_id=:id' using n_id;

Line: 938

    stmt := 'INSERT INTO edge_array_tmp VALUES (:node_id, :outedges, :inedges)';

Line: 951

              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';

Line: 975

END update_node_part_edge_arrays;

Line: 1030

  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';

Line: 1063

  update_node_part_edge_arrays;

Line: 1071

                      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';

Line: 1104

  EXECUTE IMMEDIATE 'UPDATE edge
    SET partition_id = (SELECT p_id from node_part
                          WHERE  vertex_id = start_node_id)';

Line: 1127

  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)';

Line: 1139

  EXECUTE IMMEDIATE 'INSERT /*+APPEND */ into super_edge_ids
    SELECT edge_id FROM edge_part WHERE func_class =1 or func_class = 2';

Line: 1158

     stmt := 'SELECT username FROM user_users';

Line: 1209

    name_query := 'SELECT t.name,t.geometry.sdo_ordinates FROM edge t WHERE t.edge_id = :1';

Line: 1211

    sign_query := 'SELECT to_edge_id, ' ||
                  'ramp || '':'' || exit || '':'' || toward '||
                  'FROM sign_post ' ||
                  'WHERE from_edge_id = :1';

Line: 1287

     'select t.geometry.sdo_ordinates from edge t ' ||
     'where edge_id=:i'
    INTO coords USING edge_ids(i);

Line: 1323

    stmt := 'SELECT COUNT(*) FROM SDO_ROUTER_DATA_VERSION';

Line: 1332

    stmt := 'SELECT data_version FROM SDO_ROUTER_DATA_VERSION';

Line: 1389

     delete_router_network(log_file_name, l_network_name, FALSE);

Line: 1403

    stmt := 'SELECT COLUMN_EXPRESSION FROM USER_IND_EXPRESSIONS WHERE INDEX_NAME = :name';

Line: 1424

        ' 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';

Line: 1435

        ' 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';

Line: 1452

        ' as select node_id node_id,
              partition_id partition_id,
              1 link_level
            from NODE';

Line: 1462

      ' 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';

Line: 1488

  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)';

Line: 1509

  stmt := 'insert into user_sdo_network_user_data
            (network, table_type, data_name,data_type)
           values (:1, :2, :3, :4)';

Line: 1515

  stmt := 'insert into user_sdo_network_user_data
            (network, table_type, data_name, data_type)
           values (:1, :2, :3, :4)';

Line: 1521

  stmt := 'insert into user_sdo_network_user_data
            (network, table_type, data_name, data_type)
           values (:1, :2, :3, :4)';

Line: 1527

  stmt := 'insert into user_sdo_network_user_data
            (network, table_type, data_name, data_type)
           values (:1, :2, :3, :4)';

Line: 1540

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);

Line: 1557

    log_message('ERROR: network delete failed, ' || l_network_name || ' network not found');

Line: 1558

    raise_application_error(-20020, 'Network delete failed, ' || l_network_name || ' network not found');

Line: 1561

  IF (log_delete) THEN
    log_message('INFO: deleting the Routeserver network: ' || l_network_name);

Line: 1567

  stmt := 'select node_table_name, link_table_name,
                  partition_table_name, partition_blob_table_name
           from USER_SDO_NETWORK_METADATA
           where NETWORK = :name';

Line: 1577

  stmt := 'delete from USER_SDO_NETWORK_METADATA where NETWORK = :name';

Line: 1580

  stmt := 'delete from USER_SDO_NETWORK_USER_DATA where NETWORK = :name';

Line: 1646

  stmt := 'SELECT username FROM user_users';

Line: 1779

  stmt := 'SELECT MAX(PARTITION_ID) FROM PARTITION';

Line: 1859

  stmt := 'SELECT MAX(PARTITION_ID) FROM PARTITION';

Line: 1968

    SELECT r.edge_id, partition_id, maintype, subtype, value
    FROM edge e, router_transport r
    WHERE e.edge_id=r.edge_id';

Line: 1975

  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)';

Line: 2078

  stmt := 'SELECT MAX(PARTITION_ID) FROM ROUTER_TRUCKING_DATA';

Line: 2174

    SELECT nav_strand_id, seq_num, link_id, node_id, partition_id
    FROM  edge, router_nav_strand
    WHERE edge_id=link_id';

Line: 2181

  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)';

Line: 2210

      SELECT nav_strand_id, max(seq_num)
      FROM router_nav_strand GROUP BY nav_strand_id';

Line: 2304

  stmt := 'SELECT MAX(PARTITION_ID) FROM ROUTER_TURN_RESTRICTION_DATA';