SQLCL: Trying to do Select Statement Then Do A Typical Sqlplus Type Of C/search/replace/ With Special Character Such as "$" Is Failing (Doc ID 2925912.1)

Last updated on MAY 16, 2023

Applies to:

Symptoms

Environment
================
SQLcl 22.4.0.342.1212
Database 12.1.0.2
Windows 10

Problem
============
While doing search/replace type of SQL*Plus command using SQLcl does not work as expected:

Testcase
==========
SQL> select * from v$session;
Returns the output
SQL> c/v$/gv$/
  1* select * from v$session;
SQL> c/v/gv
  1* select * from gv$session;
SQL>


Does Not Work
----------------------
If includes "$" sign

Works
-------------
Works properly if no $ sign.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.