APPS.CSF_SPATIAL_DATALOAD_PVT SQL Statements

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

Line: 111

    SELECT  column_name
    FROM    user_ind_columns
    WHERE   table_name = p_table
      AND index_name = p_index
    ORDER BY column_position ;

Line: 183

    SELECT INDEX_NAME,
          table_name
    FROM  CSF_SPATIAL_INDEX_STAT_M
    WHERE index_type = p_index_type AND index_type<>'MAT';

Line: 324

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_BLOCKS'               ||l_data_set_name, 'DELETE');

Line: 325

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_NAMES'                ||l_data_set_name, 'DELETE');

Line: 326

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACES'               ||l_data_set_name, 'DELETE');

Line: 327

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_NAMES'          ||l_data_set_name, 'DELETE');

Line: 328

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_PLACE_POSTCS'         ||l_data_set_name, 'DELETE');

Line: 329

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POIS'                 ||l_data_set_name, 'DELETE');

Line: 330

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POI_NAMES'            ||l_data_set_name, 'DELETE');

Line: 331

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_POSTCODES'            ||l_data_set_name, 'DELETE');

Line: 332

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGMENTS'         ||l_data_set_name, 'DELETE');

Line: 333

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_NAMES'       ||l_data_set_name, 'DELETE');

Line: 334

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_PLACES'      ||l_data_set_name, 'DELETE');

Line: 335

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_LF_ROADSEGM_POSTS'       ||l_data_set_name, 'DELETE');

Line: 337

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_ADM_BOUNDS'           ||l_data_set_name, 'DELETE');

Line: 338

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_HYDROS'               ||l_data_set_name, 'DELETE');

Line: 339

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_LAND_USES'            ||l_data_set_name, 'DELETE');

Line: 340

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_NAMES'                ||l_data_set_name, 'DELETE');

Line: 341

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POIS'                 ||l_data_set_name, 'DELETE');

Line: 342

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_POI_NM_ASGNS'         ||l_data_set_name, 'DELETE');

Line: 343

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RAIL_SEGS'            ||l_data_set_name, 'DELETE');

Line: 344

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RDSEG_NM_ASGNS'       ||l_data_set_name, 'DELETE');

Line: 345

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_MD_RD_SEGS'              ||l_data_set_name, 'DELETE');

Line: 346

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SDM_CTRY_PROFILES'       ||l_data_set_name, 'DELETE');

Line: 347

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_M'          ||l_data_set_name, 'DELETE');

Line: 348

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STAT_TILES_M'    ||l_data_set_name, 'DELETE');

Line: 349

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_STREET_TYPES_M'  ||l_data_set_name, 'DELETE');

Line: 350

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_SPATIAL_VER_M'           ||l_data_set_name, 'DELETE');

Line: 352

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_MAPS'         ||l_data_set_name, 'DELETE');

Line: 353

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_BINARY_TILES'        ||l_data_set_name, 'DELETE');

Line: 354

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_CONDITIONS'          ||l_data_set_name, 'DELETE');

Line: 355

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_COND_SEGS'           ||l_data_set_name, 'DELETE');

Line: 356

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_INTERVALS'           ||l_data_set_name, 'DELETE');

Line: 357

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_NODES'               ||l_data_set_name, 'DELETE');

Line: 358

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_INTVLS'       ||l_data_set_name, 'DELETE');

Line: 359

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_RDBLCK_SGMNTS'       ||l_data_set_name, 'DELETE');

Line: 360

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_ROADBLOCKS'          ||l_data_set_name, 'DELETE');

Line: 361

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGMENTS'            ||l_data_set_name, 'DELETE');

Line: 362

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_SEGM_NODES'          ||l_data_set_name, 'DELETE');

Line: 363

    DBMS_DDL.analyze_object('TABLE', 'CSF', 'CSF_TDS_TILES'               ||l_data_set_name, 'DELETE');

Line: 365

    put_stream(g_log, 'Deleted the statistics on all spatial tables');

Line: 431

   SELECT table_name, num_records
   FROM csf_spatial_stat_m; */

Line: 439

   SELECT COUNT(1)
   FROM TAB
   WHERE TNAME = p_table_name;

Line: 461

   v_query := 'SELECT table_name, num_records FROM csf_spatial_stat_m' || l_data_set_name ;

Line: 477

         v_query := 'SELECT COUNT(1) FROM ' || v_table_name;

Line: 556

    v_query1 := 'SELECT BINARY_TILE_ID, SEGMENT_LOB_SIZE, NODE_LOB_SIZE
                 FROM CSF_SPATIAL_STAT_TILES_M' || l_data_set_name;

Line: 565

      v_query2 := 'SELECT dbms_lob.getlength(SEGMENTS), dbms_lob.getlength(NODES)
                   FROM CSF_TDS_BINARY_TILES'|| l_data_set_name ||
                 ' WHERE BINARY_TILE_ID  = ' || v_binary_tile_id ;

Line: 648

  SELECT status, domidx_opstatus
  FROM all_indexes
  WHERE owner = p_owner
    AND (index_name LIKE 'CSF_MD%' OR index_name LIKE 'CSF_LF%' OR index_name LIKE 'CSF_TDS%' OR INDEX_NAME like 'CSF_WOM%')
    AND index_name = p_index_name;

Line: 656

  SELECT INDEX_NAME
  FROM CSF_SPATIAL_INDEX_STAT_M
  WHERE index_type = p_index_type AND index_type<>'MAT';

Line: 752

  SELECT status, domidx_opstatus
  FROM all_indexes
  WHERE owner = p_owner
    AND (index_name LIKE 'CSF_MD%' OR index_name LIKE 'CSF_LF%' OR index_name LIKE 'CSF_TDS%' OR INDEX_NAME like 'CSF_WOM%')
    AND index_name = p_index_name;

Line: 760

  SELECT INDEX_NAME
  FROM CSF_SPATIAL_INDEX_STAT_M
  WHERE index_type = p_index_type AND index_type<>'MAT';

Line: 861

     SELECT INDEX_NAME,
            table_name ,
            index_columns,
            index_create_sql
     FROM  CSF_SPATIAL_INDEX_STAT_M
     WHERE index_type = p_index_type AND index_type<>'MAT';

Line: 918

                select replace(l_create_sql,'l_tablespace',l_tablespace) into l_create_sql from dual;

Line: 919

                select replace(l_create_sql,'l_index',l_index_name) into l_create_sql from dual;

Line: 920

                select replace(l_create_sql,'l_table',l_table) into l_create_sql from dual;

Line: 930

                   SELECT SUBSTR(l_columns_str, 1, INSTR(l_columns_str , ',')-1) INTO l_column FROM dual;

Line: 931

                   SELECT SUBSTR(l_columns_str, INSTR(l_columns_str , ',')+1) INTO l_columns_str FROM dual;

Line: 998

      SELECT table_name,
             index_columns,
             index_create_sql,
             index_type
      INTO   l_table,
             l_columns_str,
             l_create_sql,
             l_index_type
      FROM CSF_SPATIAL_INDEX_STAT_M where INDEX_NAME = p_index_name;

Line: 1027

          SELECT replace(l_create_sql,'l_tablespace',l_tablespace) INTO l_create_sql FROM dual;

Line: 1028

          SELECT replace(l_create_sql,'l_index',p_index_name) INTO l_create_sql FROM dual;

Line: 1029

          SELECT replace(l_create_sql,'l_table',l_table) INTO l_create_sql FROM dual;

Line: 1040

           SELECT SUBSTR(l_columns_str, 1, INSTR(l_columns_str , ',')-1) INTO l_column FROM dual;

Line: 1041

           SELECT SUBSTR(l_columns_str, INSTR(l_columns_str , ',')+1) INTO l_columns_str FROM dual;