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
1
vote
3 answers

Set heading off is not working in SQLcl when set sqlformat csv

I am generating a csv output using SQLcl. set sqlformat csv set heading off select * from hr.employees where rownum < 10; …
Sabyasachi Mitra
  • 365
  • 1
  • 4
  • 12
1
vote
2 answers

sqlcl vs sqlplus pl/sql compatability

I apologize up-front for this super-lightweight question, but I'm missing something when starting to work with sqlcl as a potential replacement for sqlplus. sqlcl is compelling, but I'm troubled in that I'm missing how to run anonymous-blocks…
alexgibbs
  • 2,430
  • 2
  • 16
  • 18
0
votes
0 answers

SQLcl connect to APEX workspace

The Oracle APEX workspace is on a remote vm, which I connect to via vpn. I have only the developer role for the workspace, not a database user. Also there is no cloud account. I am trying to follow the steps described in this article:…
Zchu
  • 1
0
votes
0 answers

Not allowed to connect to Database using sqlcl

I have installed Liquibase Version: 4.21.1 and SQLcl Version: 23.1.0.089.0929 in my Windows 10 PC. Even though I have set the class paths for both, I always need to change my path to cd D:\Software\sqlcl\bin to login to Oracle database like sql…
chk.buddi
  • 554
  • 1
  • 8
  • 29
0
votes
0 answers

Cannot connect to APEX installed PDB through Liquibase command

I have installed Oracle database 21c(XE) on my local and installed Oracle Apex on 'XEPDB1'. After installing Liquibase and sqlcli, I logged in to user in XEPDB1 and tried to export Apex code using following command but it looked for the user in Xe…
chk.buddi
  • 554
  • 1
  • 8
  • 29
0
votes
1 answer

Does not connect to oracle pluggable database

I wanted to execute 'lb generate-schema -split' after installing liquibase and sqlcli but when I hit the above command it doesn't connect to pluggable database (xepdb1). It always tried to connect to 'xe' or 'orcl' service names. Can anybody help me…
chk.buddi
  • 554
  • 1
  • 8
  • 29
0
votes
0 answers

Removing unwanted characters and indentations from a json files using jq

I have to export the data from an oracle table to the new delimited JSON format. This is the command that i used in sqlcl. SET COLSEP ',' SET SQLFORMAT json; SPOOL 'C:\json_o\employee.json' SELECT * FROM employee / SPOOL OFF and the result look…
mukul bhardwaj
  • 1
0
votes
0 answers

SQLcl - Connect using keystore

Does anyone know how to pass keystore to the SQLcl command line ? ~/sqlcl/bin/sql HOST:PORT -Djavax.net.ssl.keyStore=Path to file
StillLearningToCode
  • 3
  • 2
0
votes
1 answer

Call sqlcl script hosted in a private repo in github

I can successfully do this: sql my_connection_string @script1.sql However, I am struggling to make this work, using a script hosted in a private repo. sql my_connection_string https://my_private_repo_url/script1.sql How can I make this work in a…
Javi Torre
  • 724
  • 8
  • 23
0
votes
1 answer

Pass input parameter to docker container at runtime

I have the below working docker file: # Use the Oracle SQLcl image as the base image FROM container-registry.oracle.com/database/sqlcl:latest # Set the current working directory WORKDIR /app/ # Set the TNS_ADMIN environment variable ENV TNS_ADMIN…
Javi Torre
  • 724
  • 8
  • 23
0
votes
1 answer

SQL not executing from cmd command

If I run this command in a command prompt window: start C:\sqlcl-latest\sqlcl\bin\sql /nolog sqlcl opens and, if I type: show tns My mapped TNSNames are listed. However, if I go with a single line in cmd: start C:\sqlcl-latest\sqlcl\bin\sql /nolog…
Javi Torre
  • 724
  • 8
  • 23
0
votes
1 answer

SQLCL console print to file instead of stdout

I have a .bat file which looks like this: start C:\sqlcl-latest\sqlcl\bin\sql javi/pwd@tnsname @"mypath1" The script it calls looks like this: select 1 from dual; select 2 from dual; exit; Is there any way to log everything in the cmd and the…
Javi Torre
  • 724
  • 8
  • 23
0
votes
0 answers

Close SQLCL window off after executing 2 scripts in parallel from a .bat file

I have the following .bat file that calls 2 sql scripts. start C:\sqlcl-latest\sqlcl\bin\sql javi/pwd@tnsname @"mypath1" start C:\sqlcl-latest\sqlcl\bin\sql javi/pwd@tnsname @"mypath2" However, when I execute this, the SQLCL windows that are opened…
Javi Torre
  • 724
  • 8
  • 23
0
votes
0 answers

Migration from MySQL to Oracle 19c on RHEL 8.7 Server

I have a PHP-MySQL (Symfony) application which is running on an RHEL 8.7 instance, The customer wants to migrate the database from MySQL to Oracle. I have tried to migrate it using SQL Developer installed on the local Windows machine. It is taking…
Pradeesh Kumar
  • 223
  • 2
  • 14
0
votes
0 answers

Can Liquibase (core and built-in SQLcl) commands be run using Oracle REST JDBC Driver?

I connected my Liquibase to My Oracle (OCI Cloud) Database using REST JDBC driver (https://www.oracle.com/database/sqldeveloper/technologies/db-actions/download/). I have ORDS and rest enabled schema. SQLcl Liquibase I can, without problems, connect…
rgrzegorczyk
  • 41
  • 1
  • 4
1 2
3
4 5 6