SQLcl on OTN | Getting Started Video | Downloads | FAQ | Exchange |
Version UpdatesNew Features: - Load options: SET LOADFORMAT and SET LOADMETHOD for more flexibility on loading table data
- SQLcl Liquibase Commands: ROLLBACKSQL, DIFF, DBDOC, VERSION
- Added SET CODESCAN to look for SQL Injection vulnerabilities
|
Before You Start JRE Support - SQLcl release 20.2 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_91
- Java versions 9 and 10 are not yet 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 20.2 is available for Windows 7,8,10 and Windows Server 2008/2012, Linux or Mac OS X. (See full Certification) 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
|