FilesExpand file tree

 master

/

AttachmentMVquery.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

32 lines (32 loc) · 1.1 KB

 master

/

AttachmentMVquery.sql

Top

File metadata and controls

• Code
• Blame

32 lines (32 loc) · 1.1 KB

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

27

28

29

30

31

32

select 'mkdir -p ' || substr(att.att_id,1,1)

|| '/' || substr(att.att_id,2,1)

|| '/' || substr(att.att_id,3,1)

|| '/' || substr(att.att_id,4,1)

|| '/' || substr(att.att_id,5,1)

|| '/' || substr(att.att_id,6,1)

|| '/' || att.att_id

|| '; mv ' || substr(nte.rmt_obj_id,1,1)

|| '/' || substr(nte.rmt_obj_id,2,1)

|| '/' || substr(nte.rmt_obj_id,3,1)

|| '/' || substr(nte.rmt_obj_id,4,1)

|| '/' || substr(nte.rmt_obj_id,5,1)

|| '/' || substr(nte.rmt_obj_id,6,1)

|| '/' || nte.rmt_obj_id

|| '/' || att.att_id

|| ' ' ||

substr(att.att_id,1,1)

|| '/' || substr(att.att_id,2,1)

|| '/' || substr(att.att_id,3,1)

|| '/' || substr(att.att_id,4,1)

|| '/' || substr(att.att_id,5,1)

|| '/' || substr(att.att_id,6,1)

|| '/' || att.att_id

|| '/' || att.att_id as newfile

,

att.att_id as filebase

from proposal_notepad np

,krns_nte_t nte

,krns_att_t att

where nte.rmt_obj_id = np.obj_id

and att.nte_id = nte.nte_id

and np.proposal_number = '1113';