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
8
votes
1 answer

SQLCL Batch Scripting : Auto Connection + EXPORT CSV

SQLCL is exactly what I need, but I've a big difficulty on one little thing : I want to make a script (batch file) with Auto connection and just after an EXPORT CSV (on a remote desktop : not on the server). So I'm using the pipe method with SQLCL…
Quentin T.
  • 267
  • 2
  • 8
  • 27
5
votes
4 answers

How can I connect to Oracle Database with SQLcl and SQLPlus, but without a TNSNames.ORA file?

You have: an Oracle database an Oracle Client installation, including SQL*Plus the TNS information for #1 BUT NO TNSNames.ORA file or the desire to create and maintain one How can you get your SQL*Plus connection going?
thatjeffsmith
  • 20,522
  • 6
  • 37
  • 120
3
votes
1 answer

SQLCL with Adoptopenjdk

I would like to understand some "magic", here is how to reproduce : Get SQLCL here : https://www.oracle.com/fr/database/technologies/appdev/sqlcl.html But SQLCL need jre 1.8 so get AdoptOpenJDK 8 here :…
yohannc
  • 140
  • 2
  • 9
2
votes
1 answer

Can we run javascript in sqlcl directly from command line, or do we need an sql wrapper script?

I know that I can run an sql file directly from the command line as follows: /sql -LOGON user/password@tnsname ./scripts/sql_script.sql parameter1 And I know that I can call a javascript program from within the sqlcl shell as follows: /sql>script…
crowne
  • 8,456
  • 3
  • 35
  • 50
2
votes
0 answers

sqlcl-20.4.2.35 Error Message = no ocijdbc21 in java.library.path , when trying to connect as SYSDBA

i try to connect as SYSDBA to private oracle 11g which running remotely in docker when i connect with a simple user everything working the problem is only with SYSDBA but i keep getting : C:\Dev\devops\oracle\sqlcl-20.4.2.35.2359\sqlcl\bin>sql…
user63898
  • 29,839
  • 85
  • 272
  • 514
2
votes
1 answer

How to get Oracle exception in SQLcl script when using util.execute?

I try to write a batch file using Oracles SQLcl. In this file, i want to insert a new table row with util.execute. This just returns true / false, which is a boolean return of success/failure. My question is, how i get the error message of the…
Zeussi
  • 571
  • 1
  • 9
  • 22
2
votes
1 answer

Showing full response on query on sqlcl query

I'm trying to use sqlcl on a remote server to retrieve the table definition of the tables in given oracle database. Since I have to use the cli there, I can't simply use SQLDeveloper and get the table definitions out of there (can't connect to DB…
Tim.G.
  • 299
  • 4
  • 16
2
votes
1 answer

SQLcl unable to set spool to file

In SQLcl setting spool to file gives error "SP2-0556: Invalid File Name". There are no whitespaces in file name, and the path is correct (folder C:\Temp does exist). Have tried; spool load_data.sql spool C:\Temp\load_data.sql spool…
Davor
  • 25
  • 1
  • 6
2
votes
2 answers

sqlcl errorlog configuration

I like to setup my oracle database scripts to fail in the event of any database or OS problem. I've been considering migrating to SQLCL, but the SQL*Plus approach I'd taken for detecting and triggering rollback for non-database problems is failing…
alexgibbs
  • 2,430
  • 2
  • 16
  • 18
2
votes
1 answer

Why can't I connect via jdbc using SQLcl

I can connect to a remote database using SQLDeveloper. I am trying to connect to the same database using sqlcl from the command line, but I am getting an error. Here is the command that I am running: /bin/sql…
Ben
  • 519
  • 1
  • 7
  • 14
1
vote
1 answer

How export objects to the given location in Liquibase

I have already installed Liquibase Version: 4.21.1 and SQLcl Version: 23.1.0.089.0929 and set the 'Path' in environmental variables like C:\Program Files\liquibase D:\sqlcl\bin Also, it allows me to export objects like Microsoft Windows [Version…
chk.buddi
  • 554
  • 1
  • 8
  • 29
1
vote
0 answers

Oracle APEX Liquibase Environment Data Changesets

We are in the process of trying to integrate sqlcl liquibase into our Oracle APEX deployment process. The one hiccup we came across is when we need to migrate data. Specifically, we have a table that holds data based on the environment (DEV, UAT,…
McRivers
  • 303
  • 2
  • 13
1
vote
1 answer

what is Oracle command 'o;'

I am using the oracle version. Oracle Database 11g Release 11.2.0.1.0 I accidentally ran the command o; in oracle delveloper. The result is as below. The PL/SQL procedure completed successfully. not spooling currently The sqlcl_int_runme alias has…
mjk
  • 11
  • 2
1
vote
0 answers

why does sqlcl replace "CAST" when pasting a

SQLcl: Release 21.4 Oracle Database 19c Enterprise Edition Version 19.15.0.0.0 When pasting a query into SQLcl I noticed a strange behaviour, when my query that executed fine in DBeaver had a syntax error in SQLcl. The problem is caused by auto…
Ralph Urban
  • 45
  • 6
1
vote
0 answers

Oracle SQLcl apex export "-split" option

If your application page number has more than 5 digit then "-split" option produce not page_NNNNN.sql file, but page_NNNNN_XXX.sql where XXX just some ORDER BY suffix. Therefore, the same page may be sliced to different result file (comparing to…
hinotf
  • 1,138
  • 1
  • 12
  • 22
1
2 3 4 5 6