Page MenuHomePhabricator
Authored By
stwalkerster
Mar 14 2019, 11:40 PM
Size
705 B
Referenced Files
None
Subscribers
None
select replace(sql.COLUMN_VALUE, '$$RID$$', requests.COLUMN_VALUE)
from table(sys.odcinumberlist(257498,257950,259816,260058,260117,260275,260586,260596,260636,260638,260639,260718,260729,260748,260765,260822,260995,260997,261026,261031,261039,261069,261118,261135,261215,261262,261341)) requests
cross join table(sys.odcivarchar2list(
'INSERT INTO comment (time, user, comment, visibility, request) VALUES (current_timestamp(), 7, ''self-create'', ''user'', $$RID$$);',
'UPDATE request SET status = ''Closed'', reserved = 0 WHERE id = $$RID$$;',
'INSERT INTO log (objectid, objecttype, user, action, timestamp) VALUES ($$RID$$, ''Request'', 7, ''Closed 0'', current_timestamp());'
)) sql;

File Metadata

Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
125465
Default Alt Text
raw.txt (705 B)

Event Timeline