Oracle Magazine, September/October 2018

Database Developer and DBA ETL I am generating multiple rows of output for each single row of data in my messages table with each new row containing an additional term replaced with its associated Twitter handle Hence simply by picking up the very last row using a FETCH FIRST clause I will display the result I need I recursively run a REPLACE operation using the recursive nature of the WITH statement as shown in Listing 19 Listing 19 Picking the last row with FETCH FIRST 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 10 11 select from tweetised 12 order by ind desc 13 fetch first 1 row only ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 107 IND TWEET_ TXT 7 I caught up with @ connor_ mc_ d and @ sqlmaria today They

View the Covers and the Table of Contents pages from every issue of this publication, all gathered together for easy browsing. Just flip pages and zoom as you normally do to see each issue's Cover and Table of Contents, then follow links directly to interesting content.