Is there a way to use the Toad Formatter to format a Bulk Collect Into Statement?
I would like to format it to something similar like what is shown below, every time the formatter ran, it places all the assoc.arrays onto a single line.
Currently it looks like this:
LOOP
FETCH cur_upload
BULK COLLECT INTO
upload_pages, units, datasets, jurisdictions, componenttypes, components, tags, scenarios, amounts, clients, rownums, error_msgs
LIMIT l_BulkCollect_Limit;
EXIT WHEN rownums.COUNT = 0;
. . .
END LOOP;
I want it to look like this:
LOOP
FETCH cur_upload
BULK COLLECT INTO
upload_pages,
units,
datasets,
jurisdictions,
componenttypes,
components,
tags,
scenarios,
amounts,
clients,
rownums,
error_msgs
LIMIT l_BulkCollect_Limit;
EXIT WHEN rownums.COUNT = 0;
. . .
END LOOP;
WORKAROUND:
None
STATUS:
An Enhancement request for this has been submitted for Toad for Oracle for future release.
