PL/SQL loop through a set of values

#oracle #plsql

Here’s a simple trick on how to make a PL/SQL loop iterate through a set of predefined values. This can be useful when you need to perform a report query on a set of Oracle user account, or to query a set of specific dictionary objects for example. Note that you can also make this static list a dynamically generated list. set serveroutput on ... Read more

20 Feb 2017 - less than 1 minute read