ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF3879D2E0530100007F1FF2 DIS End User Layer Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc AR طبقة المستخدم النهائي للمكتشف D Entdecker-Endbenutzerschicht E Capa de usuario final de Discoverer F Couche utilisateur final Discoverer I Livello utente finale Discoverer JA 発見者エンドユーザー層 KO Discoverer 최종 사용자 계층 PTB Camada do usuário final do Discoverer RU Уровень конечного пользователя S Discoverer-slutanvändarlager TR Discoverer son kullanıcı katmanı US Discoverer end user layer ZHS 发现者终端用户层 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 7DFEB5E60EA618A2E0530100007FD86E select ads.workbook_name workbook, ads.worksheet_name Worksheet, xxen_util.dis_user_name(ads.workbook_owner_name) workbook_owner, eqs.access_count, eqs.last_accessed, xxen_util.dis_worksheet_sql(ads.workbook_owner_name, ads.workbook_name, ads.worksheet_name) worksheet_sql, xxen_util.user_name(ads.last_updated_by) last_updated_by, xxen_util.client_time(ads.last_update_date) last_update_date from ( select distinct ads.workbook_owner_name, ads.workbook_name, ads.worksheet_name, max(ads.last_updated_by) over (partition by ads.workbook_owner_name, ads.workbook_name, ads.worksheet_name) last_updated_by, max(ads.last_update_date) over (partition by ads.workbook_owner_name, ads.workbook_name, ads.worksheet_name) last_update_date from ams_discoverer_sql ads where 1=1 ) ads, ( select upper(eqs.qs_doc_owner) qs_doc_owner, eqs.qs_doc_name, eqs.qs_doc_details, count(*) access_count, max(eqs.qs_created_date) last_accessed from &eul.eul5_qpp_stats eqs where 2=2 group by upper(eqs.qs_doc_owner), eqs.qs_doc_name, eqs.qs_doc_details ) eqs where 3=3 and ads.workbook_name=eqs.qs_doc_name(+) and ads.worksheet_name=eqs.qs_doc_details(+) order by ads.last_update_date desc Y AR DIS Worksheet SQLs Discoverer ورقة عمل استعلامات SQL. بينما يتم تخزين مستندات المصنف بتنسيق ثنائي في eul5_documents.doc_document ومن الصعب استخراج محتواها (https://community.oracle.com/thread/2494216) ، هناك وظيفة تشغيل نشطة حدد ef. * من eul_eao.eul5_functions ef حيث ef.fun_name = 'eul_trigger $ post_save_document' كتابة استعلام SQL الخاص بأوراق العمل إلى الجدول ams_discoverer_sql D DIS Worksheet SQLs Discoverer-Arbeitsblatt-SQL-Abfragen. Während die Arbeitsmappendokumente in einem binären Format in eul5_documents.doc_document gespeichert sind und es schwierig ist, ihren Inhalt zu extrahieren (https://community.oracle.com/thread/2494216), gibt es eine aktive Triggerfunktion select ef.* from eul_eao.eul5_functions ef where ef.fun_name='eul_trigger$post_save_document' Schreiben der SQL-Abfrage jedes Arbeitsblatts in die Tabelle ams_discoverer_sql E DIS Worksheet SQLs Consultas SQL de la hoja de trabajo de Discoverer. Aunque los documentos del libro de trabajo se almacenan en formato binario en eul5_documents.doc_document y es difícil extraer su contenido (https://community.oracle.com/thread/2494216), hay una función de activación activa select ef.* from eul_eao.eul5_functions ef where ef.fun_name='eul_trigger$post_save_document' escribiendo la consulta SQL de cada hoja de trabajo en la tabla ams_discoverer_sql F DIS Worksheet SQLs Feuille de travail Discoverer Requêtes SQL. Bien que les documents du classeur soient stockés dans un format binaire dans eul5_documents.doc_document et qu'il soit difficile d'extraire leur contenu (https://community.oracle.com/thread/2494216), il existe une fonction de déclenchement active sélectionnez ef.* à partir de eul_eao.eul5_functions ef où ef.fun_name='eul_trigger$post_save_document'. écrire la requête SQL de chaque feuille de calcul dans la table ams_discoverer_sql I DIS Worksheet SQLs Foglio di lavoro Discoverer interrogazioni SQL. Mentre i documenti della cartella di lavoro sono memorizzati in un formato binario in eul5_documents.doc_document ed è difficile estrarre il loro contenuto (https://community.oracle.com/thread/2494216), c'è una funzione trigger attiva select ef.* from eul_eao.eul5_functions ef where ef.fun_name='eul_trigger$post_save_document' scrivere la query SQL di ogni foglio di lavoro nella tabella ams_discoverer_sql JA DIS Worksheet SQLs DiscovererワークシートのSQLクエリ。 ワークブック文書は eul5_documents.doc_document にバイナリ形式で格納されており、その内容を抽出することは困難ですが (https://community.oracle.com/thread/2494216)、アクティブなトリガー機能があります。 select ef.* from eul_eao.eul5_functions ef where ef.fun_name='eul_trigger$post_save_document' 各ワークシートのSQLクエリをams_discoverer_sqlテーブルに書き込む KO DIS Worksheet SQLs Discoverer 워크 시트 SQL 질의. 통합 문서 문서는 eul5_documents.doc_document에 바이너리 형식으로 저장되고 콘텐츠 추출이 어렵지만 (https://community.oracle.com/thread/2494216) 활성 트리거 기능이 있습니다. ef. * from eul_eao.eul5_functions ef where ef.fun_name = 'eul_trigger $ post_save_document' ams_discoverer_sql 테이블에 각 워크 시트의 SQL 쿼리 쓰기 PTB DIS Worksheet SQLs Folha de trabalho Discoverer consultas SQL. Enquanto os documentos da pasta de trabalho são armazenados em formato binário em eul5_documents.doc_document e é difícil extrair seu conteúdo (https://community.oracle.com/thread/2494216), há uma função ativa de acionamento selecione ef.* de eul_eao.eul5_functions ef where ef.fun_name='eul_trigger$post_save_document' escrevendo a consulta SQL de cada planilha para tabela ams_discoverer_sql RU DIS Worksheet SQLs Первооткрыватель SQL-запросов рабочего листа. В то время как документы рабочей книги хранятся в бинарном формате в eul5_documents.doc_document и их содержимое трудно извлечь (https://community.oracle.com/thread/2494216), существует активная триггерная функция выбрать ef.* из eul_eao.eul5_functions ef где ef.fun_name='eul_trigger$post_save_document'' запись SQL-запроса каждой рабочей таблицы в таблицу ams_discoverer_sql S DIS Worksheet SQLs SQL-frågor för Discoverer-kalkylblad. Medan arbetsboksdokumenten lagras i binärt format i eul5_documents.doc_document och det är svårt att extrahera innehållet (https://community.oracle.com/thread/2494216), finns det en aktiv utlösarfunktion välj ef. * från eul_eao.eul5_functions ef där ef.fun_name = 'eul_trigger $ post_save_document' skriva varje kalkylblads SQL-fråga till tabellen ams_discoverer_sql TR DIS Worksheet SQLs Discoverer çalışma sayfası SQL sorguları. Çalışma kitabı belgeleri eul5_documents.doc_document içinde ikili biçimde depolanırken ve içeriğini çıkarmak zordur (https://community.oracle.com/thread/2494216), etkin bir tetikleme işlevi vardır eul_eao.eul5_functions ef'den ef. * seçin burada ef.fun_name = 'eul_trigger $ post_save_document' her çalışma sayfasının SQL sorgusunu ams_discoverer_sql tablosuna yazmak US DIS Worksheet SQLs Discoverer worksheet SQL queries. While the workbook documents are stored in a binary format in eul5_documents.doc_document and it's difficult extract their content (https://community.oracle.com/thread/2494216), there is an active trigger function select ef.* from eul_us.eul5_functions ef where ef.fun_name='eul_trigger$post_save_document' writing each worksheets' SQL query to table ams_discoverer_sql ZHS DIS Worksheet SQLs Discoverer工作表SQL查询。 虽然工作簿文档以二进制格式存储在eul5_documents.doc_document中，很难提取它们的内容(https://community.oracle.com/thread/2494216)，但有一个活跃的触发函数。 从eul_eao.eul5_functions ef中选择ef.*，其中ef.fun_name='eul_trigger$post_save_document'。 将每个工作表的SQL查询写到表ams_discoverer_sql中。 Enginatics &eul 1=1 2=2 3=3 1 10 1=1 ads.workbook_name=:workbook LOV custom Y select distinct ads.workbook_name value, xxen_util.dis_user_name(max(ads.workbook_owner_name) over (partition by ads.workbook_name))||': '||max(ads.last_update_date) over (partition by ads.workbook_name) description from ams_discoverer_sql ads order by ads.workbook_name F Cahier d'exercices US Workbook 2 20 1=1 ads.worksheet_name=:worksheet LOV custom Y select distinct ads.worksheet_name value, xxen_util.dis_user_name(max(ads.workbook_owner_name) over (partition by ads.workbook_name))||': '||max(ads.last_update_date) over (partition by ads.worksheet_name) description from ams_discoverer_sql ads where ads.workbook_name=:$flex$.workbook order by ads.worksheet_name F Feuille de travail US Worksheet 3 50 2=2 eqs.qs_created_date>sysdate-:days Number nvl(fnd_profile.value('XXEN_REPORT_DISCOVERER_IMPORT_LOV_ACCESS_HISTORY_DAYS'),90) F Nombre d'accès dans les x jours Limite aux feuilles de calcul qui ont été consultées dans un délai de x jours seulement US Access Count within x Days Restricts to worksheets that were accessed within x days only 4 70 3=3 eqs.qs_doc_name is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher uniquement Active US Show Active only 5 100 &eul <parameter_value> LOV DIS End User Layer 8E2FF36EDF3879D2E0530100007F1FF2 Y select lower(do.owner) value, do.created description from dba_objects do where do.object_type='TABLE' and do.object_name='EUL5_VERSIONS' order by do.created desc xxen_util.dis_default_eul Y F Couche de l'utilisateur final US End User Layer :$flex$.workbook Workbook Worksheet