SQLcl on OTN | Getting Started Video | Downloads | FAQ | Forum
|
New Features - Bugs Fixed
New Features
- SQL Performance Checks
- Data Guard commands for Dataguard Broker
Here is a limited list of some high priority bugs fixed for 22.1
- 3390293 DIFFERENCE IN "SET DEFINE" BEHAVIOUR BETWEEN SQLCL AND SQL*PLUS
- 33855128 SQLCL IS NOT GETTING LAUNCHED ON LINUX
- 33680680 CANNOT SET VARIABLE VALUES ACROSS SCRIPT SESSIONS
- 33649155 WPTG_TSN: DB: NEED TO KNOW STRING IS NOUN OR VERB FOR ONE WORD STRING
- 33649103 WPTG_TSN: DB: DON'T USE ALL UPPERCASE STRINGS FOR "COMMAND"
- 33647767 SP2 ERROR DOES NOT RETURNED IF SET FEEDBACK OFF
- 33837648 CONN -REST <OCID> RETURNS ERROR: INVALID OPTION
- 33905646 LIQUIBASE DIFF THROWS ERROR
- 33671914 "LIQUIBASE GENSCHEMA -SPLIT -SQL" RESULTS IN INCORRECT PARSING
- 33642372 LIQUIBASE UPDATE MESSES UP WHITESPACE / LINE BREAKS
- 33641234 SQLCL LIQUIBASE SUPPORT FOR INCLUDE AND EXCLUDE OBJECT PARAMETERS
- 33629363 SQLCL + LIQUIBASE SHOULD BE ABLE TO PERFORM ROLLBACK INDICATING A TAG
- 33624993 ROLLBACK NOT WORKING WHEN THERE ARE ROWS IN DATABASECHANGELOG_ACTIONS WITH SQL
- 33130786 LIQUIBASE IMPORTING APEX APPLICATION FAILS WITH ERROR : CANNOT INSERT NULL
- 33867123 LOAD COMMAND LOADS BY ORDER INSTEAD OF COLUMN HEADER IN SQLCL
- 33965243 REPEATED DESC COMMANDS ON PLSQL WILL EVENTUALLY BREAK THE CURRENT SESSION
- 33691403 CONNECTING TO ADBS VIA JDBC-REST (HTTPS) NOT WORKING IN MOST RECENT SQLCL VERSION
|
Before You Start JRE Support
- SQLcl release 22.1 requires Oracle Java version 11 or 17.
- 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\jdk-11.0.11
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 22.1 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
|