Problem Statement :- While working on one of the project, we came across the following requirement:- Given a list of unique IDs, check whether for each ID the data is exactly the same in the database tables of two different systems. For non-matching data dump the unique ID in a…
Sometimes our application needs to fetch a large amount of data from database systems and do some in memory processing on top of it. The SELECT query to fetch the data may contain a WHERE clause, IN operator etc and the query may return millions of rows. Our application and…
Sometimes we need to execute multiple update/insert queries on our DB. The performance of these queries can be critical for our application. We will see how we can improve performance of multiple update/insert queries on oracle. Create Index on the column/columns used in the WHERE clause for update queries. This…
What is base64 encoding? Base64 encoding schemes are commonly used to represent binary data in ASCII text. Any binary data is represented in text using only 64 characters from Ascii set. The particular set of 64 characters chosen to represent the 64 place-values for the base varies between implementations. The…