Oracle Magazine, September/October 2018
Database Developer PL SQL CREATE OR REPLACE FUNCTION singled tickers_ in IN stock_ mgr tickers_ rc ORACLE MAGAZINE SEPTEMBER OCTOBER 2018 62 RETURN stocks_ nt AUTHID DEFINER IS TYPE tickers_ aat IS TABLE OF tickers ROWTYPE INDEX BY PLS_ INTEGER l_ tickers tickers_ aat l_ singles stocks_ nt stocks_ nt BEGIN LOOP FETCH tickers_ in BULK COLLECT INTO l_ tickers LIMIT 100 EXIT WHEN l_ tickers COUNT 0 FOR indx IN 1 l_ tickers COUNT LOOP l_ singles EXTEND l_ singles l_ singles LAST stock_ ot l_ tickers indx ticker l_ tickers indx pricedate l_ tickers indx price l_ tickers indx price 5 END LOOP END LOOP
You must have JavaScript enabled to view digital editions.