FilesExpand file tree

 master

/

bind2.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

26 lines (22 loc) · 397 Bytes

 master

/

bind2.sql

Top

File metadata and controls

• Code
• Blame

26 lines (22 loc) · 397 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

set termout on

set echo on

set linesize 32000

set pagesize 1000

set trimspool on

column NAME format a3

column VALUE_STRING format a19

spool bind2.log

select * from

(select distinct

to_char(sb.LAST_CAPTURED,'YYYY-MM-DD HH24:MI:SS') DATE_TIME,

sb.NAME,

sb.VALUE_STRING

from

DBA_HIST_SQLBIND sb

where

sb.sql_id='g0v5p7v7cdjc5' and

sb.WAS_CAPTURED='YES')

order by

DATE_TIME,

NAME;

spool off