set linesize 200
set pagesize 200
col
cdate format a30
col
VALUE_STRING format a20
alter session set NLS_DATE_FORMAT='YYYY:MM:DD
HH24:MI:SS';
SELECT d.
snap_id, NAME,POSITION,DATATYPE_STRING,VALUE_STRING,LAST_CAPTURED
FROM DBA_HIST_SQLBIND d WHERE
SQL_ID='&sqlid'
order by LAST_CAPTURED,SNAP_ID,NAME desc;
Output:
SNAP_ID
|
NAME
|
POSITION
|
DATATYPE_STRING
|
VALUE_STRING
|
LAST_CAPTURED
|
78249
|
:5
|
5
|
NUMBER
|
2000
|
13/12/2016 14:54
|
78249
|
:4
|
4
|
DATE
|
12/13/2016 01:00:00
|
13/12/2016 14:54
|
78249
|
:3
|
3
|
DATE
|
11/12/2016 01:00
|
13/12/2016 14:54
|
78249
|
:2
|
2
|
NUMBER
|
3017
|
13/12/2016 14:54
|
78249
|
:1
|
1
|
VARCHAR2(128)
|
351917063556
|
13/12/2016 14:54
|
78250
|
:5
|
5
|
NUMBER
|
2000
|
13/12/2016 15:55
|
78250
|
:4
|
4
|
DATE
|
12/13/2016 15:55:29
|
13/12/2016 15:55
|
78250
|
:3
|
3
|
DATE
|
11/12/2016 15:55
|
13/12/2016 15:55
|
78250
|
:2
|
2
|
NUMBER
|
3017
|
13/12/2016 15:55
|
78250
|
:1
|
1
|
VARCHAR2(128)
|
351926355275
|
13/12/2016 15:55
|
78251
|
:5
|
5
|
NUMBER
|
2000
|
13/12/2016 16:56
|
78251
|
:4
|
4
|
DATE
|
12/13/2016 16:56:30
|
13/12/2016 16:56
|
78251
|
:3
|
3
|
DATE
|
11/12/2016 16:56
|
13/12/2016 16:56
|
78251
|
:2
|
2
|
NUMBER
|
3017
|
13/12/2016 16:56
|
78251
|
:1
|
1
|
VARCHAR2(128)
|
351966678199
|
13/12/2016 16:56
|
78252
|
:5
|
5
|
NUMBER
|
2000
|
13/12/2016 17:56
|
78252
|
:4
|
4
|
DATE
|
12/13/2016 17:56:56
|
13/12/2016 17:56
|
78252
|
:3
|
3
|
DATE
|
11/12/2016 17:56
|
13/12/2016 17:56
|
78252
|
:2
|
2
|
NUMBER
|
3017
|
13/12/2016 17:56
|
78252
|
:1
|
1
|
VARCHAR2(128)
|
351964099600
|
13/12/2016 17:56
|
|