APPS.XLA_UTILITY_PROFILER_PKG SQL Statements

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

Line: 117

l_statement_runid := 'SELECT runid       '
                ||   xla_environment_pkg.g_chr_newline
                ||   'FROM   plsql_profiler_runs   '
                ||   xla_environment_pkg.g_chr_newline
                ||   'WHERE  run_comment   = '''||xla_utility_pkg.g_unique_location||'''';

Line: 150

l_statement_unit  := 'SELECT unit_type '
                ||   xla_environment_pkg.g_chr_newline
                ||   '      ,unit_name '
                ||   xla_environment_pkg.g_chr_newline
                ||   '      ,unit_number '
                ||   xla_environment_pkg.g_chr_newline
                ||   'FROM   plsql_profiler_units  '
                ||   xla_environment_pkg.g_chr_newline
                ||   'WHERE  runid          = '||l_runid||' '
                ||   xla_environment_pkg.g_chr_newline
                ||   '  AND  unit_name NOT IN (''DBMS_PROFILER'' '
                ||   xla_environment_pkg.g_chr_newline
                ||   '                        ,'''') ';

Line: 205

      l_statement_data  := 'SELECT s.text '
              || c_chr ||  '      ,d.total_occur '
              || c_chr ||  '      ,d.total_time '
              || c_chr ||  '      ,d.min_time '
              || c_chr ||  '      ,d.max_time '
              || c_chr ||  'FROM   plsql_profiler_data    d '
              || c_chr ||  '      ,user_source            s '
              || c_chr ||  'WHERE  s.type            = ''' || l_unit_type   ||''' '
              || c_chr ||  '  AND  s.name            = ''' || l_unit_name   ||''' '
              || c_chr ||  '  AND  d.runid (+)       =   ' || l_runid
              || c_chr ||  '  AND  d.unit_number (+) =   ' || l_unit_number
              || c_chr ||  '  AND  d.line# (+)       = s.line '
              || c_chr ||  'ORDER BY '
              || c_chr ||  '       s.line';