Oracle SQL Developer – Unsupported JDK error

Today, I was trying to install the latest version of Oracle SQL Developer on my Laptop.I have Oracle SQL Developer version 20.2 already installed, and I want to install the latest release (version 21.4.3) I downloaded the latest version from:https://www.oracle.com/tools/downloads/sqldev-downloads.html I extracted the downloaded file "sqldeveloper-21.4.3.063.0100-no-jre.zip",and launched the sqldeveloper, but I got the following error: … Continue reading Oracle SQL Developer – Unsupported JDK error

Python Script to format the output of one SQL statement

I received a text file from a client that contains the output of one sql script (The output represents detailed statistics about all sql statements running in one critical database). The output is similar to the following: You can download a sample file similar to that of our client from:https://1drv.ms/u/s!ArrpKxPFc2APxRw0izNXIYqVHGdw?e=UCgUBs The output is not formatted … Continue reading Python Script to format the output of one SQL statement

Loading Arabic Data Into Oracle Database using SQLCL

This is a follow up post on my previous post:https://ahmedfattah.com/2019/12/15/loading-data-into-oracle-database-from-text-csv-files/If you read this post, you find that we uploaded some data , part of it was Arabic data, and although it was loaded successfully, the Arabic data was corrupted (appeared as ???????). In this post, we see how we can configure sqlcl to load and … Continue reading Loading Arabic Data Into Oracle Database using SQLCL

Loading Data into Oracle Database from text CSV files

In this post we are going to load data from text files (formatted as CSV “comma separated values”) into oracle database (12.1) using 3 different techniques: Oracle SQL LoaderOracle SQL DeveloperOracle sqlcl command line utility. We will just touch the above techniques; you still need to drill down for more options and more details. Environment: … Continue reading Loading Data into Oracle Database from text CSV files