Initialise arrays in PL/SQL with FOR loops inside type constructors from 21c array_var := array_type ( FOR i IN ... => val ) The loop can iterate through: A range of values ( FOR i IN min .. max => ... ) A cursor ( FOR rws in (SELECT ...) => ... )
0
13
58
2K
23
Download Image