SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extract specific data from existing column as new column

KelvinFeb 10 2020 — edited Feb 10 2020

Hi,

I have this table below with 3 columns.

I have a working query that will return the Person_ID and Modified date below.

select Person_ID, Modified
from table
where XML_String like "%KeyWord%";

What I would like is to modify this query to also include the TakeId number so my output would be as it is below.

Thanks in advance.

Kelvin

This post has been answered by Paulzip on Feb 10 2020

Jump to Answer

Added on Feb 10 2020

7 comments

1,765 views