Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Search for a string in the app (SQL queries for instance...) and know if the app is broken

BlueForest85Jan 27 2023

Hello everyone,

Here is a practical example : here is a date format I had in my SQL queries DD/MM/YYYY HH24:MI:SS
I created an application item and application computation in order to be able to replace this date format everywhere in my app in one action.
I had to manually check every page and querie, in search of this format, to replace it by the value of the app item. If the app has a lot of pages, this task can be tough.
Here is my question : is there a way to check the app in search of a string or something else. This could make the replacement work easier in this kind of case.

On the same idea, is there a way to automatically check if the app is broken ? For instance, if a table column name changes, SQL queries would fail.

Thank you for your light !

This post has been answered by jariola on Jan 27 2023
Jump to Answer
Comments
Post Details
Added on Jan 27 2023
6 comments
695 views