APPS.WF_INSTALL SQL Statements

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

Line: 31

       SELECT TABLESPACE_NAME, INITIAL_EXTENT, NEXT_EXTENT,
              PCT_INCREASE,PARTITIONED
       INTO   v_tablespace_name, v_initial, v_next,
              v_pctinc, v_partitioned
       FROM   USER_TABLES
       WHERE  TABLE_NAME = tblname;

Line: 48

      SELECT  NVL(UT.TABLESPACE_NAME,UPT.DEF_TABLESPACE_NAME),
              TO_CHAR(GREATEST(NVL(UT.INITIAL_EXTENT,
              TO_NUMBER(UPT.DEF_INITIAL_EXTENT)),65536)),
              TO_CHAR(GREATEST(NVL(UT.NEXT_EXTENT,
              TO_NUMBER(UPT.DEF_NEXT_EXTENT)),65536)),
              NVL(to_char(UT.PCT_INCREASE),UPT.DEF_PCT_INCREASE),
              UT.PARTITIONED
      INTO    v_tablespace_name, v_initial, v_next, v_pctinc, v_partitioned
      FROM    USER_PART_TABLES    UPT,
              USER_TABLES         UT
      WHERE   UT.TABLE_NAME       = tblname
      AND     UPT.TABLE_NAME(+) = UT.TABLE_NAME;

Line: 105

      SELECT  null
      INTO    v_dummy from sys.dual
      WHERE   exists (
        SELECT  1
        FROM    USER_OBJECTS
        WHERE   OBJECT_NAME = v_new_table
                      );

Line: 220

            ' as select * from %s ; \n';

Line: 293

      SELECT to_char(least(to_number(VALUE),8)),
             to_char(least(to_number(VALUE),4))
      INTO   v_freelist_groups, v_initrans
      FROM   V$PARAMETER
      WHERE  NAME = 'cpu_count';

Line: 310

      SELECT to_char(min(to_number(VALUE)))
      INTO   v_degree
      FROM   V$PARAMETER
      WHERE  NAME IN ('parallel_max_servers','cpu_count');

Line: 334

      SELECT  null
      INTO    v_dummy
      FROM    sys.dual
      WHERE   exists (SELECT 1
                      FROM   USER_OBJECTS
                      WHERE  OBJECT_NAME = v_new_table
                      );

Line: 388

              ' as select * from %s ;'||'\n';

Line: 502

    SELECT  I.TABLESPACE_NAME, I.INITIAL_EXTENT, I.NEXT_EXTENT, I.PCT_INCREASE,
            I.PARTITIONED, T.PARTITIONED
    INTO    v_tablespace_name, v_initial, v_next, v_pctinc,
            v_idxpartitioned, v_tblpartitioned
    FROM    USER_INDEXES I, USER_TABLES T
    WHERE   I.INDEX_NAME = idxname
    AND     I.TABLE_NAME = T.TABLE_NAME;

Line: 520

    SELECT  NVL(I.TABLESPACE_NAME,UPI.DEF_TABLESPACE_NAME),
            TO_CHAR(GREATEST(NVL(I.INITIAL_EXTENT,
            TO_NUMBER(UPI.DEF_INITIAL_EXTENT)),65536)),
            TO_CHAR(GREATEST(NVL(I.NEXT_EXTENT,
            TO_NUMBER(UPI.DEF_NEXT_EXTENT)),65536)),
            NVL(to_char(I.PCT_INCREASE),UPI.DEF_PCT_INCREASE),
            I.PARTITIONED, T.PARTITIONED
    INTO    v_tablespace_name, v_initial, v_next, v_pctinc,
            v_idxpartitioned, v_tblpartitioned
    FROM    USER_INDEXES I, USER_TABLES T, USER_PART_INDEXES UPI
    WHERE   I.INDEX_NAME = idxname
    AND     I.TABLE_NAME = T.TABLE_NAME
    AND     UPI.INDEX_NAME(+) = I.INDEX_NAME;

Line: 569

      SELECT null
      INTO   v_dummy
      FROM   sys.dual
      WHERE  exists (
             SELECT  1
             FROM    USER_OBJECTS
             WHERE   OBJECT_NAME = v_new_index
                    );

Line: 1122

      SELECT to_char(least(to_number(VALUE),8)),
             to_char(least(to_number(VALUE)*2,8))
      INTO   v_freelist_groups, v_initrans
      FROM   V$PARAMETER
      WHERE  NAME = 'cpu_count';

Line: 1140

      SELECT to_char(min(to_number(VALUE)))
      INTO   v_degree
      FROM   V$PARAMETER
      WHERE  NAME IN ('parallel_max_servers','cpu_count');

Line: 1166

      select null
      into   v_dummy
      from   sys.dual
      where  exists (select 1
                     from   USER_OBJECTS
                     where  OBJECT_NAME = v_new_index
                     );

Line: 1355

  select sum(bytes )/1024/1024
  into   current_space
  from   user_free_space
  where  tablespace_name = p_tablespace;

Line: 1360

  statement := 'SELECT SUM(BYTES)/1024/1024 FROM USER_SEGMENTS
  WHERE TABLESPACE_NAME = '''||p_tablespace||''' AND SEGMENT_NAME in (
  SELECT INDEX_NAME FROM USER_INDEXES WHERE PARTITIONED='||'''NO'''
  ||' AND TABLE_NAME IN ('||table_list||')
  UNION
  SELECT TABLE_NAME from USER_TABLES WHERE PARTITIONED='||'''NO'''
  ||' AND TABLE_NAME IN ('||table_list||'))';