Category Archives: PROGRAMMING

Parsing SQL CREATE query using JSQLParser

In the previous articles, we saw how to parse and Insertquery and how to parse different forms of Select query using JSQL Parser in Java. This article describes how to do the same for a Create statement. There are multiple use-cases for parsing a Create Statement. Suppose if you want to validate the table schema… Read More »

Parsing SQL SELECT query using JSQLParser

In the other article, we saw how to parse an insert query and modify the objects in the query with the help of the JSQL Parser. In this article, we will see how to use the JSQL Parser for parsing a simple select query with the basic condition and multiple select queries. Imagine a scenario… Read More »

Parsing SQL INSERT query using JSQLParser in Java

It will be fun if we can parse the SQL query to get the objects used, columns selected, getting database names, etc from the query. The use-case depends are what you are going to do after parsing and extracting the objects from the query. You may want to modify the table name and simply load… Read More »

Export Oracle table to CSV file in Java

In this post, we will see how to export a table data from Oracle to a comma-separated file(CSV). The connection to Oracle from Java can be established using the Oracle JDBC(Java Database Connectivity) The JDBC connector will be different for each RDBMS. The JDBC connector is in the form of a JAR that can be… Read More »

Export Teradata table to CSV using Java

In this post, we will see how we can connect to Teradata using the JDBC connection in Java using the credentials and copy the contents of the table to a CSV file. JDBC stands for Java Database Connector which is nothing but a set of libraries that will have supported functions to communicate with Teradata… Read More »

AES Encryption and Decryption in Java

While there are many encryption and decryption algorithms available, AES is one of the robust and reliable modes of encrypting the data. The implementation can be done in many languages as there are libraries and packages available for multiple languages. Creating the AES encryption/decryption library We do not need any special library to be downloaded… Read More »

AES Encryption using Python packages

AES stands for Advanced Encryption Standard. AES is the first and only publicly accessible cipher approved by the National Security Agency(NSA). There is multiple AES package available in python. In this post, we will see the implementation with two different packages in python Method1 – “crypto” package Method2 – “cryptography” package Using the “Crypto” AES package In this… Read More »