Many times when developing PL/SQL customizations or automations for Oracle Applications it’s useful to have a repertoire of simple queries that might be needed to either quickly test whether or not something worked, or for use in cursors when creating automations.
I wanted to share these queries because at least with the search terms I used at the time of needing them, they were not easily found. Hopefully they will help someone. I will post them to this blog as time permits and add them to this list.
Please keep in mind that these queries will probably be very simplified. They’re mainly intended to help get someone off of the ground when creating a cursor or testing, rather than be a copy-and-paste solution. Feel free to comment on the query’s blog post if you need any help.
List of Queries