By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
BANNER |
---|
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production |
PL/SQL Release 11.2.0.2.0 - Production |
CORE 11.2.0.2.0 Production |
TNS for Linux: Version 11.2.0.2.0 - Production |
NLSRTL Version 11.2.0.2.0 - Production |
REGEXP_REPLACE('03003182802','03','+923',1,1) |
---|
+923003182802 |