SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl 25.4 'show version' no longer works

Arvydas KDec 23 2025

Hello,

Even though version is still listed within help show, it is no longer available - produces error when calling show version

SQLcl build: 25.4.0.346.1855

SQL> show version
SP2-0158: unknown SHOW option "version"
SQL> help show
SHOW
----
Shows the value of a SQLcl system variable, or the current
SQLcl environment. SHOW SGA requires a DBA privileged login.

  Syntax:

  SHO[W] system_variable

where system_variables are:

  ALL                        BTITLE                     CONNECTION
  CON ID                     CON NAME                   EDITION
  EDITOR                     ENCODING                   ENCODINGS
  ERRORS                     EXTENSIONS                 HIGHLIGHTING
  INSTANCE                   JAVA                       JDBC
  KEYMAP                     LNO                        NLS
  PARAMETERS                 PDBS                       PNSO
  RECYCLEBIN                 RELEASE                    REPFOOTER
  REPHEADER                  RESTRICT                   SGA
  SOCKSPROXY                 SPOOL                      SPPARAMETERS
  SQLCODE                    STATUSBAR                  T2METRICDATA
  TNS                        TTITLE                     USER
  VERSION

Regards,
Arvydas

This post has been answered by Bilal Oumehdi-Oracle on Dec 23 2025

Jump to Answer

Added on Dec 23 2025

#sqlcl

3 comments

105 views

1 mention