Hello everyone,
Oracle version is 19C.
Here is the same query:
with testdata
as (select '13423424243;key:Appointment.ApptId,value:123;key:HSTID,value:111;' APPID from dual
union all
select '13423424243;key:Appointment.ApptId,value:124;key:HSTID,value:222;' from dual
union all
select '13423424243;key:Appointment.ApptId,value:125;key:HSTID,value:333;' from dual
union all
select '13423424243;key:Appointment.ApptId,value:126;key:HSTID,value:4444;' from dual
)
select *
from testdata;
trying to get the output like below. Thank you for your time.
ApptId
123
124
125
126