Oracle Magazine, May/June 2019
Emerging Technologies MACHINE LEARNING To facilitate her analysis and make it simpler for the audience to understand Jane decides to combine the multiple data elements into a single table via the following SQL script create table demo_ sales as select d cust_ id s prod_ id s amount_ sold d affinity_ Card d education d occupation d household_ Size d yrs_ residence from sh supplementary_ demographics d sh sales s where s cust_ id d cust_ id The best part of using the notebook is that she can enter this SQL right there in the notebook in one of the paragraphs She creates the DEMO_ SALES table and selects the data from it in the next step as shown in Figure 11 ORACLE MAGAZINE MAY JUNE 2019 100 Figure 10 Notebook first step
You must have JavaScript enabled to view digital editions.