Test Page

Index One

Index Two

Index Three

Index Four

 

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';