Oracle Magazine, September/October 2018
Database Developer and DBA ETL KING JONES SCOTT 19 APR 87 5 KING JONES SCOTT ADAMS 23 MAY 87 6 KING BLAKE 01 MAY 81 7 KING BLAKE ALLEN 20 FEB 81 8 ALTERNATIVE USE CASES The ability to run operations recursively via a single SQL statement gives rise to the ability to do recursive problem solving even when the data is not necessarily hierarchical in nature If I need to iterate through some data an unknown number of times recursion is a very effective tool for achieving this Here is an example of using recursive CTEs when it does not immediately appear to be a hierarchical problem I have a table called MESSAGES that includes some sentences containing names of my fellow developer advocates and myself I would like to replace those names with the other peoples respective Twitter handles To do that I have a lookup table called TWITTER_ HANDLES with the terms I will replace and the appropriate Twitter handles to replace them as shown in Listing 17 ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 104 Listing 17 Looking up Twitter handles SQL select from messages TXT I caught up with Connor and Maria Colgan today They have taken over AskTOM for Oracle Developers
You must have JavaScript enabled to view digital editions.