[Home] [Help]
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
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
|
|
|
|