SQLcl

Discussion List

• 
  sqlcl COPY/REPLACE implementation does not drop existing table

  Question B.Delmée 21 views 0 comments 0 points Started by B.Delmée October 12
• 
  Setting delimiter for LOAD to semicolon. Glitch?

  Question Erik van Roon 21 views 0 comments 1 point Started by Erik van Roon October 11
• 
  How to suppress schema in liquibase genobject/genschema output?

  Responded But No Solution 3020583 37 views 4 comments 0 points Most recent by thatJeffSmith-Oracle October 9
• 
  SQLcl 20.2 export apex 19.1

  Question crych 17 views 0 comments 0 points Started by crych September 23
• 
  Info with more details

  Responded But No Solution aoflima44 27 views 2 comments 0 points Most recent by aoflima44 September 17
• 
  SQLcl 20.2 places two blank lines at top of CSV file

  Responded But No Solution Jayson 22 views 1 comment 1 point Most recent by Erik van Roon September 14
• 
  Serveroutput bug got worse in 20.2

  Responded But No Solution Erik van Roon 171 views 6 comments 5 points Most recent by Tim St. H. September 14
• 
  Not able to run SQLcl in windows CMD even after setting path in environment variables.

  Solution Accepted User_ZUUOD 103 views 8 comments 0 points Most recent by User_ZUUOD September 1
• 
  Describe system dynamic views v$ failed

  danutz_68 85 views 4 comments 1 point Most recent by User273940_Dagmar August 21
• 
  SQLCL and Liquibase installing APEX applications

  Solution Accepted Alex Nuijten 183 views 1 comment 0 points Most recent by skutz-Oracle August 19
• 
  Random Ansi symbols in output text file

  Responded But No Solution 1051760 41 views 1 comment 0 points Most recent by Gaz in Oz August 14
• 
  is _RC trustworthy?

  Responded But No Solution berx 45 views 3 comments 1 point Most recent by Gaz in Oz August 14
• 
  JAVA_TOOL_OPTIONS incorrectly picked up

  Question user8632123 31 views 0 comments 1 point Started by user8632123 August 14
• 
  JAVA_HOME on Windows

  Solution Accepted David Madden 65 views 3 comments 1 point Most recent by Glen Conway August 6
• 
  NLS_LANG prevents sqlci from reading scripts

  Responded But No Solution user8632123 65 views 3 comments 0 points Most recent by Gaz in Oz August 5
• 
  SQLcl SQLPROMPT _USER value in lowercase

  Solution Accepted Mike301 74 views 3 comments 2 points Most recent by Mike301 August 3
• 
  Set ARRAYSIZE for BRIDGE command?

  Question berx 38 views 0 comments 0 points Started by berx July 24
• 
  Can I use Secure External Password Store in BRIDGE command?

  Solution Accepted berx 48 views 1 comment 0 points Most recent by berx July 24
• 
  Bug? sqlcl 20.2 doesn't honor cd for apex export

  Question peter_raganitsch 62 views 0 comments 1 point Started by peter_raganitsch July 22
• 
  Sqlcl 20.2 Liquibase package replace ORA-00955

  Question Doug Phelps 30 views 0 comments 0 points Started by Doug Phelps July 21
• 
  SQLcl

  Responded But No Solution 4201252 22 views 1 comment 0 points Most recent by Glen Conway July 21
• 
  ORA-01882 in SQLcl connection

  Question peter.ocelka 43 views 0 comments 0 points Started by peter.ocelka July 17
• 
  What is "Optimized/Unoptimized" in serveroutput?

  Solution Accepted Erik van Roon 69 views 2 comments 1 point Most recent by Erik van Roon July 13
• 
  sqlcl start and spool commands not working

  Responded But No Solution zsysdba 61 views 2 comments 0 points Most recent by zsysdba July 10
• 
  This still does not appear to work in Windows...

  Responded But No Solution user12248089 118 views 8 comments 0 points Most recent by user832387 July 10
• 
  Liquidbase - update state based on git-versioned files

  Responded But No Solution MauroPagano 91 views 2 comments 1 point Most recent by MauroPagano July 8
• 
  SQLCL Liquibase ORA-12899 error on genschema

  Responded But No Solution Doug Phelps 126 views 3 comments 0 points Most recent by Doug Phelps July 7
• 
  SQLcl 20 - java.lang.RuntimeException: Unable to parse url "..." at oracle.net.resolver.EZConnectRes

  berx 108 views 0 comments 0 points Started by berx July 6
• 
  Bug in SQLcl - ctrl-c only aborting top level script unlike SQL*Plus

  2990075 71 views 1 comment 0 points Most recent by thatJeffSmith-Oracle June 26
• 
  Reporting a BUG in handling plsql in sql

  Responded But No Solution Erik van Roon 91 views 3 comments 2 points Most recent by thatJeffSmith-Oracle June 22
• 
  Local connection library error

  Responded But No Solution 4218299 217 views 6 comments 0 points Most recent by bddda057-7788-423a-9ec8-0ed2a5d6a3c0 June 11
• 
  Not able to launch SQLCL with SQL command on CMD prompt

  Responded But No Solution User_ZUUOD 89 views 1 comment 0 points Most recent by Gaz in Oz May 19
• 
  SQLcl 19.4 - "java.lang.UnsupportedClassVersionError Bad Version number in .class file"

  Solution Accepted Mike301 78 views 4 comments 0 points Most recent by Mike301 May 12
• 
  sqlcl 18.1.1 connect / as sysdba with 11.2.0.4 DB

  Responded But No Solution dougk 4.3K views 8 comments 2 points Most recent by Mike301 May 11
• 
  I'm used to stopping the output stream of a Windows command-line program by typing ctrl-c. When I do

  Responded But No Solution RedWhiteNBlue 69 views 1 comment 0 points Most recent by Glen Conway April 30
• 
  "However, you can force a ‘thick’ connection via your Oracle Client by using the –oci flag on your c

  Responded But No Solution RedWhiteNBlue 469 views 8 comments 1 point Most recent by RedWhiteNBlue April 28
• 
  apex_export.get_application - truncated output using SQLcl v. 19.4

  Question Franco Soldera 57 views 0 comments 0 points Started by Franco Soldera April 21
• 
  Variable is a NUMBER but APEX EXPORT doesn't accept it

  Solution Accepted Franco Soldera 114 views 3 comments 1 point Most recent by Gaz in Oz April 21
• 
  Connect sequentially to multiple schemas

  Responded But No Solution user13117585 53 views 1 comment 0 points Most recent by Gaz in Oz April 20
• 
  Show Error behavior

  Question Erik van Roon 31 views 0 comments 0 points Started by Erik van Roon April 18
• 
  Incompatibility: sqlcl does not allow trailing "/" in connect identifier (while sqlplus does)

  1012248 32 views 0 comments 0 points Started by 1012248 April 12
• 
  json.value output in sqlcl vs. sqlplus

  Question Paavo 17 views 0 comments 0 points Started by Paavo April 9
• 
  Set SQLcl Path on linux

  Responded But No Solution Eric.Sacramento 114 views 6 comments 1 point Most recent by Eric.Sacramento March 19
• 
  sqlcl script run query based on database version

  Solution Accepted Marek Läll 89 views 3 comments 0 points Most recent by Erik van Roon March 18
• 
  Exporting numbers using SQLcl while retaining the original decimal and thousand separator

  Responded But No Solution 3841192 229 views 1 comment 0 points Most recent by user6350053 March 15
• 
  SQLcl Version 19.4.0.354.1736 format rules works for FORMAT BUFFER and doesn't work for FORMAT FILE

  Responded But No Solution User800507-Oracle 117 views 3 comments 0 points Most recent by user9944749 March 4
• 
  How can I run sql script in background?

  Responded But No Solution macdoor 16.4K views 11 comments 1 point Most recent by Turloch O'Tierney-Oracle March 4
• 
  Java limitation:lower versions of SQLCL available?

  Responded But No Solution kirilb_123 2.6K views 8 comments 1 point Most recent by User_RLK2I March 4
• 
  "index preferences task" no arranca V.19.2.1

  Responded But No Solution 0329166d-eed3-414f-b465-fa1b31dad93e 203 views 1 comment 0 points Most recent by Glen Conway February 28
• 
  sql script changes working directory (linux)

  Question B.Delmée 36 views 0 comments 0 points Started by B.Delmée February 25