select created, to_char(signature), sql_handle, sql_text, origin, last_verified, enabled, accepted from dba_sql_plan_baselines order by 1; SQL> / CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 25-FEB-24 02.27.55.780978 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 3338725627101229094 SQL_2e558944bddcb026 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT sql_handle, plan_name, origin, enabled, accepted, CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- fixed, optimizer CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 25-FEB-24 02.28.32.925134 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 4022507629801686773 SQL_37d2d1608ca0c6f5 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT /*+ gather_plan_statistics NO_ADAPTIVE_PLAN */ sum(t1.c), sum(t2.c) FROM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 25-FEB-24 02.28.32.951237 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 4572969578260333623 SQL_3f76739a50e00437 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT * CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- FROM table(DBMS_XPLAN.DISPLAY_CURSOR(FORMAT=>'ALLSTATS LAST +cost +byte CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 25-FEB-24 02.29.54.080748 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 7133561626005174419 SQL_62ff8080ed657893 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT DISTINCT SQL_HANDLE FROM DBA_SQL_PLAN_BASELINES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 25-FEB-24 02.49.26.445083 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 4262901236495707176 SQL_3b28de16b9e66c28 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET' CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 25-FEB-24 07.38.33.278124 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 3338725627101229094 SQL_2e558944bddcb026 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT sql_handle, plan_name, origin, enabled, accepted, CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- fixed, optimizer CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 10.00.04.000000 PM YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- NO CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 10.45.27.923276 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 2490706085944436925 SQL_2290c3fd249f28bd CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT INST_ID,INSTANCE_NUMBER FROM GV$INSTANCE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 10.45.28.836517 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 10691826517852517234 SQL_9460ff91fcb37372 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT COUNT(*) FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME = :B1 AND OWNER ='ORACLE_ CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 10.45.28.964064 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 15317894302813570784 SQL_d49417b5f22ec6e0 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT PARALLEL FROM V$INSTANCE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 10.45.28.981229 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 18369123656701261055 SQL_feec3ca458e734ff CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT DBID FROM V$DATABASE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 10.45.29.012383 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 6854104167049572323 SQL_5f1eab6ce283afe3 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT VERSION FROM V$INSTANCE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 10.45.29.022020 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 11706218175067960855 SQL_a274d7687425b617 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT SUBSTR(VALUE,1,5) FROM V$PARAMETER WHERE LOWER(NAME) = 'compatible' CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 10.45.29.039335 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 9922594484807840074 SQL_89b4231c9d38b14a CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT NAME FROM V$DATABASE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 11.05.35.895720 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 14750549226687150997 SQL_ccb47a5eb299bb95 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- select name from v$datafile CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 11.11.38.763887 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 1549801052513213718 SQL_1581ffd897939d16 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- select distinct CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- (case when cd.dbid = wr.dbid and CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 11.11.38.807141 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 13608023999935706228 SQL_bcd969bac3287474 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- select 'X' CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- from AWR_PDB_database_instance CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- where instance_number = : CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 11.11.38.814348 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 5384458268817253059 SQL_4ab9704474c462c3 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- select to_char(max(end_interval_time),'dd/mm/yyyy') CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- from AWR_PDB_snapshot CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 11.12.59.318324 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 2687449541523495280 SQL_254bbd1e8a4b5970 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- select end_interval_time, startup_time CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- from AWR_PDB_snapshot CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- where sna CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 11.16.42.950097 AM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 9599191742190826003 SQL_85372e07e425b213 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT NAME NAME_COL_PLUS_SHOW_PARAM,DECODE(TYPE,1,'boolean',2,'string',3,'integ CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.05.51.455213 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 11082399836523089214 SQL_99cc97ef2ace4d3e CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT COMPARISON_ID FROM COMPARISON$ WHERE USER# = :B1 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.05.51.865919 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 5653704212504012861 SQL_4e75fe06d36e683d CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- DELETE FROM SYSTEM.SQLPLUS_PRODUCT_PROFILE WHERE USERID = ORA_DICT_OBJ_NAME CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.07.48.368489 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 12866477607687511539 SQL_b28ee936f4bb5df3 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- INSERT INTO CUSTOMERS SELECT CUSTOMER_ID_SEQ.NEXTVAL,DBMS_RANDOM.STRING('P',DBMS CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.07.48.507548 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 13498721727318297985 SQL_bb5517e446a78d81 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- INSERT INTO ITEM_MASTER SELECT ITEM_ID_SEQ.NEXTVAL,DBMS_RANDOM.STRING('P',DBMS_R CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.07.48.949053 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 13708565695281527111 SQL_be3e9bde675c7947 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- INSERT INTO ITEM_SALE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- (ITEM_SALE_ID,ITEM_ID,ITEMS_SOLD,ITEM_SALE_DATE,ITEM_SOLD_ CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.21.20.577793 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 8072964416758256848 SQL_7008ee5d593e94d0 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT COUNT(1) FROM customers CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.21.20.646216 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 1190625189652638074 SQL_1085f34d41e0a97a CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- INSERT INTO ITEM_MASTER SELECT ITEM_ID_SEQ.NEXTVAL,DBMS_RANDOM.STRING('P',DBMS_R CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.21.46.893834 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 17356537772236670937 SQL_f0decf251cd107d9 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT COUNT(1) FROM ITEM_SALE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.28.22.878337 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 14026631467128697442 SQL_c2a89b00c985b262 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- INSERT INTO ITEM_SALE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- (ITEM_SALE_ID,ITEM_ID,ITEMS_SOLD,ITEM_SALE_DATE,ITEM_SOLD_ CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 01.34.17.011451 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 15126315443529218538 SQL_d1eb77c0d41079ea CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- INSERT INTO ITEM_SALE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- (ITEM_SALE_ID,ITEM_ID,ITEMS_SOLD,ITEM_SALE_DATE,ITEM_SOLD_ CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 03.21.29.204078 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 5061382014695063552 SQL_463da42042734000 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- INSERT INTO ITEM_MASTER SELECT ITEM_ID_SEQ.NEXTVAL,DBMS_RANDOM.STRING('P',DBMS_R CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 03.21.34.062638 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 11602509687539019520 SQL_a10465168ccaaf00 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- INSERT INTO ITEM_SALE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- (ITEM_SALE_ID,ITEM_ID,ITEMS_SOLD,ITEM_SALE_DATE,ITEM_SOLD_ CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 03.29.31.547216 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 1301635994712028723 SQL_1210570a73ac3633 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT D.CON_DBID ,SUBSTR(D.NAME, 1, :B1 ) ,SUBSTR(SYS_CONTEXT('USERENV', 'CON_N CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 03.29.31.603077 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 3432104551078291188 SQL_2fa148e7b705e6f4 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- SELECT UPPER(CDB), SYS_CONTEXT('USERENV','CON_ID') FROM V$DATABASE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 03.29.31.626305 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 11166131559608120806 SQL_9af6117e25b875e6 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- select i.instance_number inst_num CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- , 'ALL' instance_numbers_or_a CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 28-FEB-24 03.29.33.848969 PM CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 10395943744484713097 SQL_9045cfc16af4a289 CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- select to_char(s.startup_time,'dd Mon "at" HH24:mi:ss') instart_fmt CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- AUTO-CAPTURE CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- YES CREATED --------------------------------------------------------------------------- TO_CHAR(SIGNATURE) SQL_HANDLE ---------------------------------------- ------------------------------ SQL_TEXT -------------------------------------------------------------------------------- ORIGIN ----------------------------- LAST_VERIFIED ENA --------------------------------------------------------------------------- --- ACC --- 35 rows selected. SQL>