Oracle Magazine, September/October 2018
Database Developer and DBA ETL ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 105 SQL select from twitter_ handles ID TERM HANDLE 1 Connor McDonald @ connor_ mc_ d 2 Connor @ connor_ mc_ d 3 Maria Colgan @ sqlmaria 4 Oracle Developers @ otndev 5 Oracle @ oracle 6 AskTOM @ oracleasktom This means that for each of the rows in TWITTER_ HANDLES I need to continually iterate through all the rows of data in my MESSAGES table each time replacing a found term with its appropriate Twitter handle until all the terms have been exhausted as shown in Listing 18 Listing 18 Selecting tweets and replacing names with Twitter handles SQL with 2 tweetised ind tweet_ txt as 3 4 select 1 ind txt tweet_ txt 5 from messages 6 union all 7 select ind 1 replace tweet_ txt term handle 8 from tweetised twitter_ handles 9 where ind id
You must have JavaScript enabled to view digital editions.