Stack Overflow
Stack Overflow

Questions tagged [sqlcl]

sqlcl is a command line interface for Oracle databases.

sqlcl is a command line inteface for Oracle databases. It is similar to SQL*Plus but contains additional features such as in-line editing and auto-completion.

Questions with the tag should probably also have the tag.

81 questions
0
votes
0 answers

sqlcl hangs when called using popen from airflow

We're having an issue kicking off a subprocess.Popen within an airflow operator. We're using the following code to kick off sqlcl: import subprocess cmd = '/usr/local/bin/sqlcl -V' p = subprocess.Popen( cmd, shell=True, …
2ps
  • 15,099
  • 2
  • 27
  • 47
0
votes
0 answers

oracle - sqlcl.exe login error: Could not initialize class sun.management.ManagementFactoryHelper

Using oracle's sqlcl, I was able to use SPOOL to create data dump files on my dev computer. However, when I tried to run sqlcl on a windows server, with java installed, it gave this error: C:\path>sql.exe username/password@connection_string SQLcl:…
Cal
  • 747
  • 1
  • 13
  • 30
0
votes
0 answers

How to Fetch all rows Parallelli in PL/SQL. I want to export 100 million rows in csv for the ETL

I want to export 100 million rows in CSV File. I am using SQL DEVELOPER AND SQL CL but the fetching is taking so much time. I am using following SQL command in SQL CL. SET FEEDBACK OFF SET SQLFORMAT CSV ALTER SESSION SET NLS_NUMERIC_CHARACTERS =…
Kalyan Purohit
  • 1
0
votes
3 answers

run sql script using SQLCL in python

I've discovered Oracle's SQLCL and have been able to make it work in the terminal. I've also been able to make it work in Python, up through entering the actual SQL query. My code in Python looks like this: import subprocess import time import…
Blake Shurtz
  • 321
  • 3
  • 13
0
votes
1 answer

Connect Oracle database with SQLcl

I am using sqldeveloper to query database and export results to csv file. I need this file on daily basis so thought of creating bat file which can be scheduled on windows task scheduler. I was researching it and found I can use SQLcl to run my…
mak101
  • 147
  • 1
  • 11
0
votes
1 answer

Using SQLcl in maven java project

I'm trying to use SQLcl in my maven Java project, but I cannot figure out how to use it. What I have tried so far: I downloaded the latest SQLcl (sqlcl-19.4.0.354.0937.zip) from oracle. I extracted all the files into a local folder. I then opened…
W0lfw00ds
  • 2,018
  • 14
  • 23
0
votes
0 answers

Initiating .bat file (connecting to Oracle via SQLcl) from MS Excel VBA macro

I'm writing a macro that needs to: Start .bat file Wait until .bat file is finished (data is downloaded from Oracle to .csv via SQLcl) Continue executing rest of VBA I found two solutions for that problem: First one - via Shell: Dim shell_command…
Krzysztof Zurek
  • 1
  • 2
0
votes
0 answers

Oracle SQL Developer Command-Line (SQLcl) - cannot start Oracle sql.bat (sqlcl)

Not sure if this is Windows or Oracle related problem. I never used sqlcl and wanted to give it a go after installing Oracle 19c software and ORCL database on Windows 19. My PATH: PATH=C:\Program Files (x86)\Common…
user1863063
  • 21
  • 7
0
votes
1 answer

SQL command to print .SQL filename

Is there any SQL command to print the name of the .SQL file that is currently being executed in the sqlplus prompt? There's is a Unix way to do it. But I am looking for a valid SQL command that displays the current filename.
user10473909
0
votes
1 answer

how to get the length of the string in sqlcl

i am trying to display the top three rows based on their length of the string in names.but the system just reads the predefined length of the string column not the string in the column SQL> select max(length(name)) from…
Mr Josh
  • 120
  • 2
  • 11
0
votes
1 answer

Sqlcl - Error Message = no ocijdbc18 in java.library.path

I set the below environment variables and running below command from sqlcl, sql $ABC_DB_PROD_USERNAME/$ABC_DB_PROD_PASSWORD@"$ABC_DB_PROD_TNS" I am getting Error Message = no ocijdbc18 in java.library.path I have no idea what should I do.
Gangs165700
  • 111
  • 8
0
votes
1 answer

SQLCL - Unexpected Java Exception when SQL errors exist in referenced files

I am experiencing different behaviors using SQLCL when sql errors are encountered in scripts on command line vs separate sql file. Original script, command line - expected sql error set errorlogging on show errorlogging TRUNCATE TABLE…
Shawn
  • 1,871
  • 2
  • 21
  • 36
0
votes
1 answer

unable to connect to sqlcl with a username containing $ using the EzConnect syntax

I am trying to connect to an Oracle database schema whose username contains $, ex: ABCD$EFG ./sql.bat ABCD$EFG/dbpassword@dbhostname:1521:dbservicename The username is wrongly identified as ABCD instead of ABCD$EFG. USER = ABCD URL …
Sridhar Jammalamadaka
  • 1
  • 2
0
votes
2 answers

SQLcl, select statement, resultant formatting of the data doesn't abide by the heading column width

I am using oracle SQLcl: Release 4.2.0. When I issue this sort of select statement: column COLUMN_A format a8 column COLUMN_B format a8 column COLUMN_C format a8 column COLUMN_D format a8 set linesize 1300 select * from table1 where rownum <= 10…
Steve T
  • 165
  • 11
0
votes
2 answers

Not Able to connect to Oracle Autonomous Datawarehouse Cloud using any of the way

I am trying to connect to the Oracle Autonoumous Datawarehouse using JDBC Thin connections and wallet using below ways: 1. SQLDeveloper 2. Sqlcl I am following the steps mentioned in…
user2519513
  • 1
  • 2
1 2 3 4
5
6