Index One
This first tag is almost the same as any other HTML tag you would use to create a link to another page. However, to create a bookmark (anchor), you must start the link with a # (pound symbol,) which represents a name statement, used in the next tag. When the user clicks on the “Top” link, the computer would then go to the name tag, if found on the same page of the link.
SET lines 220 pages 49999
COLUMN name format a30
COLUMN datatype_string format a30
COLUMN was_captured format a15
COLUMN value_string format a50
COLUMN value_anydata format a30
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
SELECT inst_id,
address,
hash_value,
name,
position,
datatype_string,
was_captured,
last_captured,
value_string
FROM gv$sql_bind_capture
WHERE sql_id ='&sql_id'
AND was_captured='YES'
ORDER BY inst_id;
SET lines 220 pages 49999 COLUMN NAME format a30 COLUMN datatype_string format a30 COLUMN was_captured format a15 COLUMN value_string format a50 COLUMN value_anydata format a30 ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SELECT inst_id, address, hash_value, NAME, position, datatype_string, was_captured, last_captured, value_string FROM gv$sql_bind_capture WHERE sql_id ='&sql_id' AND was_captured='YES' ORDER BY inst_id;
COLUMN name format a30 COLUMN datatype_string format a30 COLUMN was_captured format a15 COLUMN value_string format a50 COLUMN value_anydata format a30 ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SELECT inst_id, address, hash_value, name, position, datatype_string, was_captured, last_captured, value_string FROM gv$sql_bind_capture WHERE sql_id ='&sql_id' AND was_captured='YES' ORDER BY inst_id;
COLUMN name format a30 COLUMN datatype_string format a30 COLUMN was_captured format a15 COLUMN value_string format a50 COLUMN value_anydata format a30 ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SELECT inst_id, address, hash_value, name, position, datatype_string, was_captured, last_captured, value_string FROM gv$sql_bind_capture WHERE sql_id ='&sql_id' AND was_captured='YES' ORDER BY inst_id;
COLUMN name format a30 COLUMN datatype_string format a30 COLUMN was_captured format a15 COLUMN value_string format a50 COLUMN value_anydata format a30 ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SELECT inst_id, address, hash_value, name, position, datatype_string, was_captured, last_captured, value_string FROM gv$sql_bind_capture WHERE sql_id ='&sql_id' AND was_captured='YES' ORDER BY inst_id;
Index Two
This first tag is almost the same as any other HTML tag you would use to create a link to another page. However, to create a bookmark (anchor), you must start the link with a # (pound symbol,) which represents a name statement, used in the next tag. When the user clicks on the “Top” link, the computer would then go to the name tag, if found on the same page of the link.
Index Three
This first tag is almost the same as any other HTML tag you would use to create a link to another page. However, to create a bookmark (anchor), you must start the link with a # (pound symbol,) which represents a name statement, used in the next tag. When the user clicks on the “Top” link, the computer would then go to the name tag, if found on the same page of the link.
Index Four
This first tag is almost the same as any other HTML tag you would use to create a link to another page. However, to create a bookmark (anchor), you must start the link with a # (pound symbol,) which represents a name statement, used in the next tag. When the user clicks on the “Top” link, the computer would then go to the name tag, if found on the same page of the link.
COLUMN sql_text format a100 SELECT sql_id, sql_text FROM v$sql WHERE sql_id='&sql_id';