When trying to run the sqlcl version 22.1 on my new laptop (Windows 11 with many oracle database homes), I got the following errors: I have many oracle homes on my machine (Oracle Database 12cR1, 12cR2, 18c, 19c & 21c). After long research, it looks like that sqlcl pick the JRE under the environment ORACLE_HOME. … Continue reading sqlcl java errors under different database homes
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
Ahmed AbdelFattah Blog ! 