DBA Data[Home] [Help]
Skip to content

VIEW: SYS.INT$DBA_HIST_SQL_BIND_METADATA

Source

View Text - Preformatted

select dbid, sql_id, name, position, dup_position,
       datatype, datatype_string,
       character_sid, precision, scale, max_length,
       decode(con_dbid, 0, dbid, con_dbid),
       con_dbid_to_id(decode(con_dbid, 0, dbid, con_dbid)) con_id
  from WRH$_SQL_BIND_METADATA
View Text - HTML Formatted

SELECT DBID
, SQL_ID
, NAME
, POSITION
, DUP_POSITION
, DATATYPE
, DATATYPE_STRING
, CHARACTER_SID
, PRECISION
, SCALE
, MAX_LENGTH
, DECODE(CON_DBID
, 0
, DBID
, CON_DBID)
, CON_DBID_TO_ID(DECODE(CON_DBID
, 0
, DBID
, CON_DBID)) CON_ID
FROM WRH$_SQL_BIND_METADATA