Change command in Oracle

You can use the Change command to Change the string (that is, replace the string ). Syntax: C [HANGE] sepcharold [sepchar [new [sepchar] Sepchar is the Separator

You can use the Change command to Change the string (that is, replace the string ). Syntax: C [HANGE] sepchar old [sepchar [new [sepchar] Sepchar is the Separator

You can use the Change command to Change the string (that is, replace the string ). Syntax:

C [HANGE] sepchar old [sepchar [new [sepchar]

Sepchar is the separator, which can be "/" or "!" -- Special attention

Old string

New String

For example, to change the division number (/) to the multiplication number (*), the command must be c! /! *!. That is:
SQL> l
1 * select sal, sal/100 from emp
SQL> c! /! *!

Reminder: only modified/characters can be used! As a separator (for example above ).

For example, to change the multiplication sign (*) to the plus sign (+), run the following command: c! /! *! . That is:
SQL> l
1 * select sal, sal * 100 from emp
SQL> c/*/+/
1 * select sal, sal + 100 from emp
SQL>

For more information about Oracle, see the Oracle topic page? Tid = 12