1Our web application uses Oracle database and
2I normally write queries to do Data validation.
3For example:
4I create data from UI or I send POST request
5from API then I write query to verify that data
6was successfully and correctly inserted into database.
7Our database consists of many tables, so most of the time,
8I need to write queries that involve joins.
9
10CAN MENTION: Since our application has large sets of
11data, data is stored into Oracle and to another CACHE database.
12I write queries to test data that both are in SYNC(same).