Help us understand the problem. What is going on with this article?

ACCEPTしたSQLプロファイルの一覧を表示する

More than 5 years have passed since last update.

Oracle Database 11g R2 (11.2.0.3) Enterprise Editionで動作確認済み。

SET LONG 1000
SET LONGCHUNKSIZE 1000
SET LINESIZE 255
SET TRIMS ON
ALTER SESSION SET nls_timestamp_format = 'YYYY/MM/DD HH24:MI';
COL name FORMAT a30
COL category FORMAT a10
COL sql_text FORMAT a80
COL created FORMAT a20
COL last_modified FORMAT a20
COL force_matching FORMAT a5 HEADING 'FORCE|MATCH'
SELECT name, category, created, last_modified, force_matching, sql_text
  FROM dba_sql_profiles
 ORDER BY created DESC;
Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away