Oracle replace function to delete sub-string
select replace('abc', 'a') from dual;
REPLACE('abc','a')
---------------------------
bc
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/638844/viewspace-772752/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle function overviewOracleFunctionView
- Oracle Table FunctionOracleFunction
- oracle function powerOracleFunction
- Oracle Regexp_ReplaceOracle
- oracle REPLACE 函式 介紹Oracle函式
- oracle INTERNAL_FUNCTIONOracleFunction
- Oracle Deterministic FunctionOracleFunction
- oracle中translate與replace的使用Oracle
- oracle delete 分批刪除Oracledelete
- Oracle Pipelined FunctionOracleFunction
- oracle function函式castOracleFunction函式AST
- BIRT呼叫oracle function薦OracleFunction
- a demo function of oracle for AKingFunctionOracle
- Oracle merge into delete語法Oracledelete
- Oracle Delete表恢復(ODU)Oracledelete
- How To Delete An Oracle Applications UserdeleteOracleAPP
- Oracle基礎之function使用OracleFunction
- oracle create function 例項2OracleFunction
- Oracle Profile and PASSWORD_VERIFY_FUNCTIONOracleFunction
- Oracle RMAN的show,list,crosscheck,deleteOracleROSdelete
- oracle truncate 與 delete 的區別Oracledelete
- oracle之DELETE後的恢復Oracledelete
- ORACLE—DELETE表後的恢復Oracledelete
- 構建oracle function的小示例OracleFunction
- Oracle Date Function 講解和事例OracleFunction
- oracle9i replace clob 的一個bugOracle
- javascript 中function(){},new function(),new Function(),Function 摘錄JavaScriptFunction
- JavaScript replace()JavaScript
- mysql replaceMySql
- Oracle中truncate和delete的區別Oracledelete
- Oracle中，一個Delete操作的流程Oracledelete
- Oracle vs PostgreSQL Develop（28） - function overloadOracleSQLdevFunction
- oracle11中的char_functionOracleFunction
- oracle create function的兩個例項OracleFunction
- Oracle 中 replace函式和translate函式比較Oracle函式
- Oracle11gr2新增CREATE OR REPLACE FORCE TYPE功能Oracle
- ORACLE HANDBOOK系列之一：Oracle分析函式（Analytic Function）Oracle函式Function
- replace函式函式