Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table table1(Name varchar(10), "image description" varchar(100));
insert into table1 values ('x', '<text:hello xmlns:text="uri://google.com/" image="xxx" />')
1 rows affected

insert into table1 values ('b', null)
1 rows affected

insert into table1 values ('y', '<text:hi xmlns:text="uri://google.com/" image="yyy" />')
1 rows affected

insert into table1 values ('z', '<text:bi xmlns:text="uri://google.com/" image="yyy" />')
1 rows affected

insert into table1 values ('a', null)
1 rows affected

create table table2("image id" int, image varchar(10));
insert into table2("image id", image) values (1, 'xxx')
1 rows affected

insert into table2("image id", image) values (2, 'yyy')
1 rows affected

insert into table2("image id", image) values (3, 'zzz')
1 rows affected

select t1.Name, t2."image id"
from table1 t1 left join table2 t2
on t1."image description" like '%image="' || t2.image || '" />'


NAME
image id


x
1

b
null

y
2

z
2

a
null

NAME	image id
x	1
b	null
y	2
z	2
a	null