Solution 1:
check this
with sub1 as
(
select /*+ materialize */ A.field
from table1 A
left join table2@remotedb B on A.id = B.id
)
select field || 'x'
from sub1
ora 22992 on a LOB field i am not using
Solution 1:
check this
with sub1 as
(
select /*+ materialize */ A.field
from table1 A
left join table2@remotedb B on A.id = B.id
)
select field || 'x'
from sub1