DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC_SYNC SQL Statements

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

Line: 10

    select
      appName,
      groupName,
      testClassName,
      versions
    from
      JTF_DIAGNOSTIC_LOG;
Line: 41

  delete from JTF_DIAGNOSTIC_CMAP
  where
	appName = key1
  and	groupName = key2
  and	testClassName = key3;
Line: 87

  insert into JTF_DIAGNOSTIC_CMAP(
	appName,
	groupName,
	testClassName,
	classname)
  values (
	key1,
	key2,
	key3,
	className);