replace function in dml statements in oracle 8i
Posted
by maheshasoni
on Stack Overflow
See other posts from Stack Overflow
or by maheshasoni
Published on 2010-04-10T06:17:31Z
Indexed on
2010/04/10
6:23 UTC
Read the original article
Hit count: 184
Oracle
Can we use Replace function in a update statement ? If yes then How? I have a column 'enrollno' having values like '800-00001' to '800-01800'. I want to replace inital '800-' to '800' in all 1800 records. (Output should be '8000001' to '80001800') Is it possible through replace function or any other option is there in ORACLE8i ? MaheshA...
© Stack Overflow or respective owner
