Oracle Magazine, September/October 2018
Database Developer PL SQL the job done For example you can use INSERT ALL to insert into tickers twice ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 51 INSERT ALL INTO tickers ticker pricedate pricetype price VALUES ticker trade_ date O opening_ price INTO tickers ticker pricedate pricetype price VALUES ticker trade_ date C closing_ price SELECT FROM stocks You could also use UNPIVOT thanks Chris Saxon @ chrisrsaxon for making me aware of this technique INSERT INTO tickers ticker
You must have JavaScript enabled to view digital editions.