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;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center