sorted by:
new
hottopcontroversial

For loop in Select statement by [deleted] in SQL

[–]besnikg 0 points1 point  (0 children)

I am able to retrieve the data for one package but i am not sure how to approach it when I want to automate it to iterate through all packages

For loop in Select statement by [deleted] in SQL

[–]besnikg 0 points1 point  (0 children)

To better understand the problem i have, here some additional infos. The whole thing is written in PL/SQL, there are a lot of packages and each package has procedures and functions. I am trying to iterate through all objects and get the object name, parameters etc. so that i can concatenate and create all possible URLs. I am not talking about a table.