Check Bind Variable History

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

 

Comments