Oracle Magazine, July/August 2018
Database Developer PL SQL ORACLE MAGAZINE JULY AUGUST 2018 112 DECLARE l_ strings strings_ t random_ strings 5 BEGIN FOR indx IN 1 l_ strings COUNT LOOP DBMS_ OUTPUT put_ line l_ strings indx END LOOP END And heres an example of the output you might see but likely not because these values are produced by a sophisticated pseudorandom generator KKEMEEIPES QOZKUGIFWF CDYPAOTORD PHRPCHZQIT LOUVRRMWBX And now I forgo the PL SQL block along with the declaration of a local variable and simply call the function in a query SELECT COLUMN_ VALUE my_ string FROM TABLE random_ strings 5
You must have JavaScript enabled to view digital editions.