showbind.sql
指定したSQLのバインド変数を確認する
code:SQL
break on CHILD_NUMBER skip 1
alter session set nls_date_format='yyyy/mm/dd hh24:mi:ss';
col NAME for a15
col VALUE_STRING for a20
col DATATYPE for a15
set lines 130
select SQL_ID,CHILD_NUMBER,NAME,POSITION,VALUE_STRING,DATATYPE_STRING DATATYPE,LAST_CAPTURED
from V$SQL_BIND_CAPTURE
where SQL_ID = '&1'
order by CHILD_NUMBER,POSITION;
@default_settings