No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions
 

Oracle SQL Developer Command Line (SQLcl) 21.3 Release Notes

October 2021

SQLcl on OTN | Getting Started Video | Downloads | FAQ | Forum

New Features - Bugs Fixed

New Features

  • ADD SUPPORT FOR SET AUTOTRACE (set autotrace trace explain) - suppresses query output
  • LIQUIBASE, ADDED -SQL OPTION SQL SCRIPT CHANGESETS
  • LIQUIBASE, LIBRARY UPDATED TO 4.4.2

 

Here is a limited list of some high priority bugs fixed for 21.3

  • 33327605 UPDATE ORACLE ERROR MESSAGES FOR ORA, TNS AND DGM
  • 33302451 EXPOSE ORACLEDATASOURCE#SETHOSTNAMERESOLVER() API IN DATASOURCEBUILDER
  • 33297559 PARSING ISSUES WITH LOAD COMMAND
  • 33175248 NUMBERS ARE GETTING ROUNDED
  • 33174868 NON ENGLISH LOCALE CAUSES DECIMAL NUMBERS TO LOSE PRECISION/ROUNDING ON LOAD
  • 33225307 SET LOADFORMAT DELIMITER NOT WORKING
  • 33291501 ADD SUPPORT FOR SET AUTOTRACE
  • 33176200 UNABLE TO RESTRICT CREATE AND ALTER FOR HISTORY FILTER
  • 33088568 SQLCL TRYING TO GRAB 2GB MEMORY MAX, JAVA_TOOL_OPTIONS: -XMX800M NOT WORKING
  • 33109569 ERROR IN LB GENSCHEMA SCRIPTS WHEN LOADED WITH DB_LINKS
  • 33048582 ABILITY TO GENERATE XML-LESS SQL SCRIPTS FOR BASELINES WITH LIQUIBASE
  • 33333919 DIRECTORY STRUCTURE INCONSISTENCIES IN ORACLE LINUX 8
  • 33093909 INCORRECT COLUMN WIDTH FOR DATE WHEN FIRST COLUMN IS NULL
  • 33051543 INTERMITTENT ISSUE IN QUERY OUTPUT FORMAT

Here is a limited list of some high priority bugs fixed for 21.2.2

  • 33145474 - CONSOLE OUTPUT ISN'T GOING INTO SPOOLED FILE
  • 33112651 - APEX COMMAND IS NOT WORKING
  • 33110791 - 'APEX' AND 'APEX LIST' -> JAVA.LANG.ILLEGALARGUMENTEXCEPTION
  • 33067043 - NOT ABLE TO CONNECT TO A CLOUD WALLET
  • 33042805 - UNEXPECTED STACK TRACE ON CTRL-C
  • 33042314  - FAILS TO LOOKUP CREDENTIALS IN CLOUD WALLET WHEN SERVICE ALIAS DIFFERS BY CASE ALONE
  • 32992687 - INCONSISTENT FORMATTING OF THE IN LIST
  • 32978109 - TNSNAMES AND PLSQL BLOCK VARIABELS IN THE COMPLETER
  • 32939436 - LIQUIBASE(LB) GENSCHEMA ERROR IF SCHEDULE JOB NAME CONTAIN '$'
  • 32913587 - SHELL SCRIPT WARNING WHEN CONNECTING TO DB FROM SQLCL WITH JKS PARAMETERS
  • 32805033 - COMPLETION INSIGHT FOR COLUMNS IN A SECOND QUERY
  • 32153318 - LIQUIBASE ABILITY TO HAVE THE DB COMPONENT XML FILES PLACED INTO FOLDERS

 

Before You Start

JRE Support

  • SQLcl release 21.3 requires Java version 1.8 and above. Go here to download the latest version.
  • If SQLcl cannot find a local JRE, you will be prompted to enter the location path for the JRE. Note that the prompt wants only the folder, not the java.exe.  For example C:\Program Files\Java\jre1.8.0_262
  • Java versions 9 and 10 are not supported.

Known Issues

  • Invoking SQL Recall for a previous statement which has a line exceeding the width of your display, the in-line editor will be unable to access or edit the line with the overflow. Workaround this issue by resizing your terminal display wide enough to prevent line-wrapping.
 


Platform Support

  • SQLcl release 21.3 is available for Windows 10 and Windows Server 2008/2012, Linux or Mac OS X. (See full Certification)
  • If using a OCI “Thick” connection type, a 21c Oracle Client will be required


 
Installing or Upgrading

All new releases of SQLcl and SQL Developer require a full installation. Download and unzip the file into an empty folder. Ensure the "Use folder names" checkbox is checked when unzipping the file.
 

Support

Production Releases - you are supported by Oracle Support under your current database Support license for SQL Developer production releases. Log SQL Developer bugs and issues using My Oracle Support for the product.

Feedback

There are a number of different forums supporting the features in SQLcl. When using the forums, be sure to use clear subject lines to initiate a thread and try to avoid using old, unrelated threads for a new issue.


SQL*Plus List of Unsupported Commands and Features

Commands 
  •  REPHEADER
  •  REPFOOTER

  • System Variables and Environment Settings via the SET Command

    • autoprint
    • autorecovery
    • cmdsep
    • copytypecheck
    • describe
    • eschar
    • flagger
    • flush
    • fullcolname
    • logsource
    • loboffset
    • markup
    • recsep
    • recsepchar
    • shiftinout
    • sqlcase
    • sqlprefix
    • sqlterminator
    • tab
    • underline
    • xmloptimizationcheck