By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Table1
(query_name varchar(136))
;
INSERT INTO Table1
(query_name)
VALUES
('SELECT * FROM SYSIBM.SQLCOLUMNS'),
('SELECT * FROM SYSIBM.SYSDUMMY1'),
('SELECT CCID, CCCODE FROM V820.ZCC ZCC JOIN V820.ZCI ZCI ON ZCC.CCID = ZCI.CCID WHERE trim(CCCODE) NOT IN (''89090'',''89089'',''89087'')'),
('SELECT * FROM V820.IIM')
;
4 rows affected
Select
SUBSTRING(query_name,CHARINDEX('from ', lower(query_name)) + 5,CHARINDEX(' ', lower(query_name + ' '), CHARINDEX('from ', lower(query_name)) + 5) - CHARINDEX('from ', lower(query_name)) - 5) query_name
from Table1
| query_name |
|---|
| SYSIBM.SQLCOLUMNS |
| SYSIBM.SYSDUMMY1 |
| V820.ZCC |
| V820.IIM |