ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEDA79D2E0530100007F1FF2 DBA Username Y select du.username value, null description from dba_users du order by du.username US 4DF02316AAA4454BE0535CCD0A55BDF5 select ds.* from ( select ds.owner, ds.type, ds.name, ds.line, ds.text, &multi_line_text null multi_line_text from dba_source ds where 1=1 ) ds where 2=2 order by ds.name, ds.line Y AR DBA Text Search البحث عن نص كامل من خلال كائنات التعليمات البرمجية المصدر لقاعدة البيانات مثل الحزم والإجراءات والوظائف والمشغلات وما إلى ذلك. D DBA Text Search Volltextsuche durch Datenbank-Quellcode-Objekte wie Pakete, Prozeduren, Funktionen, Trigger usw. E DBA Text Search Búsqueda de texto completo en los objetos del código fuente de la base de datos, como paquetes, procedimientos, funciones, disparadores, etc. F DBA Text Search Recherche en texte intégral dans les objets du code source de la base de données tels que les paquets, les procédures, les fonctions, les déclencheurs, etc. I DBA Text Search Ricerca a tutto testo attraverso oggetti del codice sorgente del database come pacchetti, procedure, funzioni, trigger, ecc. JA DBA Text Search パッケージ、プロシージャ、関数、トリガーなどのデータベースのソースコードオブジェクトをフルテキストで検索します。 KO DBA Text Search 패키지, 프로 시저, 함수, 트리거 등과 같은 데이터베이스 소스 코드 개체를 통한 전체 텍스트 검색 PTB DBA Text Search Busca de texto completo através de objetos de código fonte do banco de dados, tais como pacotes, procedimentos, funções, gatilhos, etc. RU DBA Text Search Полнотекстовый поиск по объектам исходного кода базы данных, таким как пакеты, процедуры, функции, триггеры и др. S DBA Text Search Fulltextsökning genom källkodsobjekt i databasen som paket, procedurer, funktioner, triggers etc. TR DBA Text Search Paketler, prosedürler, işlevler, tetikleyiciler vb. Gibi veritabanı kaynak kodu nesneleri aracılığıyla tam metin araması US DBA Text Search Full text search through database source code objects such as packages, procedures, functions, triggers etc. The search can also be done using regular expressions. To retrieve incorrect custom code such as a frequent performance issue calling the fnd_concurrent\.wait_for_request\s function with a zero interval time, for example, use parameter 'Multi Line Regex search' with the following value: fnd_concurrent\.wait_for_request\s*\(\s*request_id\s*=>\s*\w+\s*,\s*interval\s*=>\s*0\s*, ZHS DBA Text Search 通过数据库源码对象，如包、程序、函数、触发器等进行全文检索。 Enginatics &multi_line_text 1=1 2=2 1 10 1=1 lower(ds.text) like '%'||lower(:search_text)||'%' Char F Le texte du code contient US Code Text contains 2 15 2=2 regexp_like(ds.multi_line_text,:multi_line_search,'i') Char US Multi Line Regex search 3 16 1=1 grw Char US Cote Text Regexp search 4 17 &multi_line_text select 'case when sum(lengthb(ds.text)) over (partition by ds.owner, ds.type, ds.name order by ds.line rows between '||x.level_||' preceding and current row)<4000 then '||case when x.level2<0 then 'lag' else 'lead' end||'(ds.text,'||abs(x.level2)||') over (partition by ds.owner, ds.type, ds.name order by ds.line) end||' multi_line_text from (select level-1 level_, level-:line_window/2 level2 from dual connect by level<:line_window) x LOV custom Y select level*2 value, null description from dual where :$flex$.multi_line_regex_search is not null connect by level<26 select 10 from dual where :$flex$.multi_line_regex_search is not null US Multi Line window size 5 20 1=1 ds.name like upper(:object_name)||'%' Char F Le nom de l'objet commence par US Object Name starts with 6 30 1=1 ds.text like '%'''||(select fnm.message_name from fnd_new_messages fnm where fnm.message_text=:message_text and rownum=1)||'''%' LOV custom Y Y select fnm.message_text value, fnm.language_code||': '||fnm.message_name description from fnd_new_messages fnm order by fnm.message_text F Texte du message du FND US FND Message Text 7 40 1=1 ds.type=:object_type LOV custom Y select 'PACKAGE' value, 'Package Header' description from dual union all select 'PACKAGE BODY' value, 'Package Body' description from dual union all select 'PROCEDURE' value, 'Procedure' description from dual union all select 'FUNCTION' value, 'Function' description from dual union all select 'TRIGGER' value, 'Trigger' description from dual union all select 'TYPE' value, 'Type' description from dual union all select 'TYPE BODY' value, 'Type Body' description from dual union all select 'LIBRARY' value, 'Library' description from dual union all select 'JAVA SOURCE' value, 'Java Source' description from dual F Type d'objet US Object Type 8 50 1=1 ds.owner=:owner LOV DBA Username 8E2FF36EDEDA79D2E0530100007F1FF2 Y select du.username value, null description from dba_users du order by du.username APPS F Schéma US Schema 9 60 1=1 ds.line>=:line_number_from Number US Line Number From 10 70 1=1 ds.line<=:line_number_to Number :$flex$.line_number_from+500 US Line Number To :$flex$.line_number_from Line Number From Line Number To :$flex$.multi_line_regex_search Multi Line Regex search Multi Line window size Zero fnd_concurrent.wait_for_request interval ANDY.HAACK 4 LINE 6 MULTI_LINE_TEXT 3 NAME 1 OWNER 5 TEXT 2 TYPE Multi Line Regex search fnd_concurrent\.wait_for_request\s*\(\s*request_id\s*=>\s*\w+\s*,\s*interval\s*=>\s*0\s*\W Object Name starts with xx S Site ANDY.HAACK Zero fnd_concurrent.wait_for_request interval