If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> Summer 13 Issue 50<br /> 50 editions of invaluable industry<br /> insight helping you make the<br /> most of your Oracle investment<br /> 50 editions of real-life<br /> experience and in-depth articles<br /> from leading professionals<br /> OracleScene<br /> Serving the Oracle Community<br /> 50<br /> Welcome th<br /> to our edition of the independent, flagship<br /> publication for Oracle users<br /> This edition's<br /> sponsor:www.ukoug.org<br /> An independent publication<br /> not affiliated with Oracle Corporation<br /> OracleScene<br /> SUMMER 13<br /> Welcome to the 50th edition<br /> Here's to another 50!<br /> As the 50th edition of OracleScene is distributed, all of us at UKOUG pause to reflect and consider<br /> how we have gotten this far. It has been a huge, immensely gratifying undertaking. The pleasure<br /> of designing and producin<a title="Oracle Scene Issue 50 page 1" href="http://viewer.zmags.com/publication/3294d168?page=1"> Summer 13 Issue 50 50 editions of invaluable </a> <a title="Oracle Scene Issue 50 page 2" href="http://viewer.zmags.com/publication/3294d168?page=2"> OracleScene SUMMER 13 Welcome to the 50th editio</a> <a title="Oracle Scene Issue 50 page 3" href="http://viewer.zmags.com/publication/3294d168?page=3"> Summer 13 Issue 50 Run ADF for Free! Building</a> <a title="Oracle Scene Issue 50 page 4" href="http://viewer.zmags.com/publication/3294d168?page=4"> </a> <a title="Oracle Scene Issue 50 page 5" href="http://viewer.zmags.com/publication/3294d168?page=5"> Oracle Scene Editorial Team Editor Geoff Swaffer </a> <a title="Oracle Scene Issue 50 page 6" href="http://viewer.zmags.com/publication/3294d168?page=6"> OracleScene DIGITAL SUMMER 13 Welcome to Oracle </a> <a title="Oracle Scene Issue 50 page 7" href="http://viewer.zmags.com/publication/3294d168?page=7"> UKOUG pays tribute to Graham Gilbert UKOU</a> <a title="Oracle Scene Issue 50 page 8" href="http://viewer.zmags.com/publication/3294d168?page=8"> SUMMER 13 News and Reviews UKOUG Appoints Maste</a> <a title="Oracle Scene Issue 50 page 9" href="http://viewer.zmags.com/publication/3294d168?page=9"> News and Reviews Knowledge sharing at its best </a> <a title="Oracle Scene Issue 50 page 10" href="http://viewer.zmags.com/publication/3294d168?page=10"> SUMMER 13 Focus on: Apps13 Conference OracleScen</a> <a title="Oracle Scene Issue 50 page 11" href="http://viewer.zmags.com/publication/3294d168?page=11"> Focus on: Apps13 Conference What can you expect </a> <a title="Oracle Scene Issue 50 page 12" href="http://viewer.zmags.com/publication/3294d168?page=12"> OracleScene DIGITAL SUMMER 13 Focus on: Apps13 C</a> <a title="Oracle Scene Issue 50 page 13" href="http://viewer.zmags.com/publication/3294d168?page=13"> THE BREWERY, LONDON 14-16 OCTOBER 2013 ...on the</a> <a title="Oracle Scene Issue 50 page 14" href="http://viewer.zmags.com/publication/3294d168?page=14"> OracleScene DIGITAL SUMMER 13 Applications Transf</a> <a title="Oracle Scene Issue 50 page 15" href="http://viewer.zmags.com/publication/3294d168?page=15"> Applications Transformation: Debra Lilley users</a> <a title="Oracle Scene Issue 50 page 16" href="http://viewer.zmags.com/publication/3294d168?page=16"> Please tell us what you do in Oracle. My name is </a> <a title="Oracle Scene Issue 50 page 17" href="http://viewer.zmags.com/publication/3294d168?page=17"> come from BEA from the acquisition – how do you f</a> <a title="Oracle Scene Issue 50 page 18" href="http://viewer.zmags.com/publication/3294d168?page=18"> </a> <a title="Oracle Scene Issue 50 page 19" href="http://viewer.zmags.com/publication/3294d168?page=19"> Technology Set based ETL with DML Error Handling</a> <a title="Oracle Scene Issue 50 page 20" href="http://viewer.zmags.com/publication/3294d168?page=20"> SUMMER 13 Technology: Peter Hamilton entire se</a> <a title="Oracle Scene Issue 50 page 21" href="http://viewer.zmags.com/publication/3294d168?page=21"> SQL> desc ph_test_1 Name </a> <a title="Oracle Scene Issue 50 page 22" href="http://viewer.zmags.com/publication/3294d168?page=22"> SUMMER 13 Technology: Peter Hamilton Index Vio</a> <a title="Oracle Scene Issue 50 page 23" href="http://viewer.zmags.com/publication/3294d168?page=23"> rows in the source table. The error arises when a</a> <a title="Oracle Scene Issue 50 page 24" href="http://viewer.zmags.com/publication/3294d168?page=24"> SUMMER 13 Technology: Peter Hamilton So the ro</a> <a title="Oracle Scene Issue 50 page 25" href="http://viewer.zmags.com/publication/3294d168?page=25"> </a> <a title="Oracle Scene Issue 50 page 26" href="http://viewer.zmags.com/publication/3294d168?page=26"> OracleScene DIGITAL SUMMER 13 Technology </a> <a title="Oracle Scene Issue 50 page 27" href="http://viewer.zmags.com/publication/3294d168?page=27"> In this article I’m going to give you a whistle-s</a> <a title="Oracle Scene Issue 50 page 28" href="http://viewer.zmags.com/publication/3294d168?page=28"> OracleScene DIGITAL SUMMER 13 Technology: Grant </a> <a title="Oracle Scene Issue 50 page 29" href="http://viewer.zmags.com/publication/3294d168?page=29"> Interestingly enough some of the UX solutions the</a> <a title="Oracle Scene Issue 50 page 30" href="http://viewer.zmags.com/publication/3294d168?page=30"> OracleScene DIGITAL SUMMER 13 Technology B</a> <a title="Oracle Scene Issue 50 page 31" href="http://viewer.zmags.com/publication/3294d168?page=31"> And to make the choices even more difficult: Hybr</a> <a title="Oracle Scene Issue 50 page 32" href="http://viewer.zmags.com/publication/3294d168?page=32"> SUMMER 13 Technology: Roel Hartman </a> <a title="Oracle Scene Issue 50 page 33" href="http://viewer.zmags.com/publication/3294d168?page=33"> Technology: Roel Hartman </a> <a title="Oracle Scene Issue 50 page 34" href="http://viewer.zmags.com/publication/3294d168?page=34"> OracleScene DIGITAL SUMMER 13 Technology Run </a> <a title="Oracle Scene Issue 50 page 35" href="http://viewer.zmags.com/publication/3294d168?page=35"> FIGURE 1 To check that your demo database runs,</a> <a title="Oracle Scene Issue 50 page 36" href="http://viewer.zmags.com/publication/3294d168?page=36"> SUMMER 13 Technology: Sten Vesterli FIGURE 3 </a> <a title="Oracle Scene Issue 50 page 37" href="http://viewer.zmags.com/publication/3294d168?page=37"> User interface For the user interface, just open </a> <a title="Oracle Scene Issue 50 page 38" href="http://viewer.zmags.com/publication/3294d168?page=38"> OracleScene DIGITAL SUMMER 13 Technology Op</a> <a title="Oracle Scene Issue 50 page 39" href="http://viewer.zmags.com/publication/3294d168?page=39"> of the I/O system, such as a read or a write, and</a> <a title="Oracle Scene Issue 50 page 40" href="http://viewer.zmags.com/publication/3294d168?page=40"> OracleScene DIGITAL SUMMER 13 Technology: James </a> <a title="Oracle Scene Issue 50 page 41" href="http://viewer.zmags.com/publication/3294d168?page=41"> It should by now be very evident that the use of </a> <a title="Oracle Scene Issue 50 page 42" href="http://viewer.zmags.com/publication/3294d168?page=42"> OracleScene DIGITAL SUMMER 13 Technology Keys</a> <a title="Oracle Scene Issue 50 page 43" href="http://viewer.zmags.com/publication/3294d168?page=43"> sequence you could do a surprising amount of DML </a> <a title="Oracle Scene Issue 50 page 44" href="http://viewer.zmags.com/publication/3294d168?page=44"> SUMMER 13 Technology: Jonathan Lewis the b</a> <a title="Oracle Scene Issue 50 page 45" href="http://viewer.zmags.com/publication/3294d168?page=45"> leaf block splits for N-1 of the N prefixes will </a> <a title="Oracle Scene Issue 50 page 46" href="http://viewer.zmags.com/publication/3294d168?page=46"> OracleScene DIGITAL SUMMER 13 Business Strategy </a> <a title="Oracle Scene Issue 50 page 47" href="http://viewer.zmags.com/publication/3294d168?page=47"> Business Strategy: Mitesh Shah and busines</a> <a title="Oracle Scene Issue 50 page 48" href="http://viewer.zmags.com/publication/3294d168?page=48"> SUMMER 13 Business Strategy: Mitesh Shah Choos</a> <a title="Oracle Scene Issue 50 page 49" href="http://viewer.zmags.com/publication/3294d168?page=49"> Supplier Guide SUPPLIER GUIDE A list of suppli</a> <a title="Oracle Scene Issue 50 page 50" href="http://viewer.zmags.com/publication/3294d168?page=50"> How did you get into IT? It was a long time ago a</a> <a title="Oracle Scene Issue 50 page 51" href="http://viewer.zmags.com/publication/3294d168?page=51"> Interview: David Warburton-Broadhurst Are </a> <a title="Oracle Scene Issue 50 page 52" href="http://viewer.zmags.com/publication/3294d168?page=52"> OracleScene DIGITAL SUMMER 13 Technology Oracl</a> <a title="Oracle Scene Issue 50 page 53" href="http://viewer.zmags.com/publication/3294d168?page=53"> on which of the two scripts we call. In this case</a> <a title="Oracle Scene Issue 50 page 54" href="http://viewer.zmags.com/publication/3294d168?page=54"> SUMMER 13 Technology: Eter Pani For such scrip</a> <a title="Oracle Scene Issue 50 page 55" href="http://viewer.zmags.com/publication/3294d168?page=55"> $ ./Main.sh Please input your username: test_user</a> <a title="Oracle Scene Issue 50 page 56" href="http://viewer.zmags.com/publication/3294d168?page=56"> SUMMER 13 Technology: Eter Pani MainScript.sq</a> <a title="Oracle Scene Issue 50 page 57" href="http://viewer.zmags.com/publication/3294d168?page=57"> Technology In-database Sentiment Analysis By th</a> <a title="Oracle Scene Issue 50 page 58" href="http://viewer.zmags.com/publication/3294d168?page=58"> SUMMER 13 Technology: Hüsnü Şensoy movie_revie</a> <a title="Oracle Scene Issue 50 page 59" href="http://viewer.zmags.com/publication/3294d168?page=59"> Building Featureset Building a classification mod</a> <a title="Oracle Scene Issue 50 page 60" href="http://viewer.zmags.com/publication/3294d168?page=60"> SUMMER 13 Technology: Hüsnü Şensoy </a> <a title="Oracle Scene Issue 50 page 61" href="http://viewer.zmags.com/publication/3294d168?page=61"> Now right click on Filter Rows component and choo</a> <a title="Oracle Scene Issue 50 page 62" href="http://viewer.zmags.com/publication/3294d168?page=62"> SUMMER 13 Technology: Hüsnü Şensoy </a> <a title="Oracle Scene Issue 50 page 63" href="http://viewer.zmags.com/publication/3294d168?page=63"> Once the execution is done you should see a green</a> <a title="Oracle Scene Issue 50 page 64" href="http://viewer.zmags.com/publication/3294d168?page=64"> OracleScene DIGITAL SUMMER 13 Technology Oracl</a> <a title="Oracle Scene Issue 50 page 65" href="http://viewer.zmags.com/publication/3294d168?page=65"> Technology: Kathiravan Udayakumar Essential SOA</a> <a title="Oracle Scene Issue 50 page 66" href="http://viewer.zmags.com/publication/3294d168?page=66"> SUMMER 13 Technology: Kathiravan Udayakumar </a> <a title="Oracle Scene Issue 50 page 67" href="http://viewer.zmags.com/publication/3294d168?page=67"> SOA Data Manipulation Framework SOA Data Manipula</a> <a title="Oracle Scene Issue 50 page 68" href="http://viewer.zmags.com/publication/3294d168?page=68"> OracleScene DIGITAL SUMMER 13 Technology: Kathir</a> <a title="Oracle Scene Issue 50 page 69" href="http://viewer.zmags.com/publication/3294d168?page=69"> SOA Cross Reference Framework SOA Cross Reference</a> <a title="Oracle Scene Issue 50 page 70" href="http://viewer.zmags.com/publication/3294d168?page=70"> OracleScene DIGITAL SUMMER 13 Book Reviews Ora</a> <a title="Oracle Scene Issue 50 page 71" href="http://viewer.zmags.com/publication/3294d168?page=71"> UKOUG News Anna’s fundraiser for the street kid</a> <a title="Oracle Scene Issue 50 page 72" href="http://viewer.zmags.com/publication/3294d168?page=72"> Getting Answers = More Reports I just want to see</a> <a title="Oracle Scene Issue 50 page 73" href="http://viewer.zmags.com/publication/3294d168?page=73"> UKOUG Governance Get to know who on the Council i</a> <a title="Oracle Scene Issue 50 page 74" href="http://viewer.zmags.com/publication/3294d168?page=74"> IF YOU’RE NOT IN YOU OUGHT TO BE. </a>