DBA_HIST_SQLTEXT


SQL> desc DBA_HIST_SQLTEXT
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------------
 DBID                                      NOT NULL NUMBER
 SQL_ID                                    NOT NULL VARCHAR2(13)
 SQL_TEXT                                           CLOB
 COMMAND_TYPE                                       NUMBER



set long 20000
select sql_text from dba_hist_sqltext
where dbid=&dbid
and sql_id='&SQL_ID'
/








Comments