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

Oracle Database 19c (19.3) Installation on Windows (Step-by-Step)

This is a quick post about installing Oracle Database 19c (19.3) on my laptop (Windows 10). Procedure will be presented as screen cast. As far as I remember, Oracle 19c was released during Mar-2019 for Linux, and during Apr-2019 for SPARC Solaris and during Jun-2019 for Windows,zLinux , HP and AIX Software Download: First of … Continue reading Oracle Database 19c (19.3) Installation on Windows (Step-by-Step)

sqlcl Multi-Line Paste Issue

What is the issue? I noticed that sometimes when I copy SQL statement from web and paste it on sqlcl , it is copied on many lines and generating errors. For example, when I copied the following statement: And pasted into sqlcl running on the windows command window, it was pasted as follows: So, it … Continue reading sqlcl Multi-Line Paste Issue