SELECT A.STAT_ID FROM DBA_HIST_STAT_NAME A WHERE A.STAT_NAME = 'execute count' AND A.DBID = (SELECT B.DBID FROM DBA_HIST_DATABASE_INSTANCE B WHERE B.DB_NAME = :db_name AND ROWNUM = 1) AND ROWNUM = 1表1:サンプルSQLに使用する値リスト値リスト「stat_id」について補足します...
protected by means of encryption.' AS VALUE FROM dba_tables a WHERE a.tablespace_name NOT IN (select t.name from v$tablespace t, v$encrypted_tablespaces e where t.ts# = e.ts# ) AND a.tablespace_name NOT IN ('SYSTEM','SYSAUX','UD1','TEMP','SYSEXT','UNDOTBS') AND ROWNUM < 200...
%script SELECT CUST_ID, ROUND(CLUSTER_PROBABILITY(KM_SH_CLUS3, 5 USING *),3) PROB FROM CUSTOMERDATA WHERE rownum < 10 ORDER BY PROB DESC; CUST_ID PROB 102308 0.539 101232 0.502 101610 0.374 102828 0.303 100134 0.302 103948 0.297 100696 0.25 103791 0.141 100804 0.104 9 rows selected. -...