How do you use sql in you company

Our web application uses Oracle database and 
I normally write queries to do Data validation. 
For example: 
I create data from UI or I send POST request
from API then I write query to verify that data
was successfully and correctly inserted into database.
Our database consists of many tables, so most of the time,
I need to write queries that involve joins.

CAN MENTION: Since our application has large sets of
data, data is stored into Oracle and to another CACHE database.
I write queries to test data that both are in SYNC(same).

Similar codes

16 votes164 views4 answers
Sort by sql
SQL
2 votes234 views1 answer
Flask sqlalchemy boolean field
SQL
-1 vote193 views1 answer
Mysql delete duplicate rows except one
SQL
6 votes174 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote172 views1 answer
Mysql update even / odd rows
SQL
10 votes168 views4 answers
Primary key sql
SQL
0 vote164 views1 answer
Sql server set complex constraints
SQL
9 votes154 views1 answer
Mysql check date range
SQL
0 vote170 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote156 views1 answer
Java spring boot connect to sql server
SQL