FilesExpand file tree

master

/

sqlpatch_history.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

26 lines (21 loc) · 548 Bytes

master

/

sqlpatch_history.sql

Copy path

Top

File metadata and controls

• Code
• Blame

26 lines (21 loc) · 548 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 LINESIZE 600

SET PAGESIZE 1000

COLUMN action FORMAT A10

COLUMN description FORMAT A90

COLUMN action_time FORMAT A22

--COLUMN logfile FORMAT A80

COLUMN status FORMAT A10

COLUMN version FORMAT A8

prompt **********************

prompt ** SQLPatch History **

prompt **********************

prompt

select r.patch_id,

r.action,

TO_CHAR(r.action_time, 'DD-MI-YYYY HH24:MI:SS') AS action_time,

r.description,

-- r.logfile,

r.status,

r.version

from sys.registry$sqlpatch r

order by r.action_time desc;