DBA Data[Home] [Help]

APPS.FND_DEBUG_UTIL SQL Statements

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

Line: 29

      select version
        into dbversion
        from v$instance;
Line: 63

    select DECODE(value, NULL, NULL, '_' || value)
      into t_ident
      from v$parameter
     where name='tracefile_identifier';
Line: 108

      select name, value
        from v$parameter
        where name='db_name' or name like 'user_dump%';
Line: 113

      select p.spid
        from v$session s, v$process p
        where s.audsid = aud_sid and s.paddr=p.addr;
Line: 130

    select userenv('SESSIONID') into audsid from dual;
Line: 148

    select dbms_utility.port_string into platform from dual;
Line: 162

    select DECODE(instr(upper(platform), 'WIN_NT') , 0, '/', '\')
      into dir_sep
      from dual;
Line: 187

      select host_name
        into node_name
        from v$instance;
Line: 223

      update fnd_debug_rule_executions
         set log_request_id = req_id
       where transaction_id = fnd_log.g_transaction_context_id
         and debug_option_name = 'PLSQL_PROFILER';