| 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
|