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
6data was successfully and correctly inserted
7into database. Our database consists of
8many tables, so most of the time,
9I need to write queries that involve joins.
10
11CAN MENTION: Since our application has
12large sets of data, data is stored into
13Oracle and to another CACHE database.
14I write queries to test data that both are in SYNC(same).