易截截图软件、单文件、免安装、纯绿色、仅160KB

oracle 的两个替换函数 REPLACE TRANSLATE


replace就是一般意义上的字符串替换,translate只是一个字符替换对应的一个字符,下面有手册说明,还有例子 O(∩_∩)O哈哈~
REPLACE
Syntax
Purpose
REPLACE returns char with every occurrence of search_string replaced with replacement_string. If replacement_string is omitted or null, then all occurrences of search_string are removed. If search_string is null, then char is returned.
Both search_string and replacement_string, as well as char, can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is in the same character set as char. The function returns VARCHAR2 if the first argument is not a LOB and returns CLOB if the first argument is a LOB.
REPLACE provides functionality related to that provided by the TRANSLATE function. TRANSLATE provides single-character, one-to-one substitution. REPLACE lets you substitute one string for another as well as to remove character strings.
Examples
The following example replaces occurrences of J with BL:
SELECT REPLACE('JACK and JUE','J','BL') "Changes"
from DUAL;
Changes
--------------
BLACK and BLUE
TRANSLATE
Syntax
PurposeTRANSLATE returns expr with all occurrences of each character in from_string replaced by its corresponding character in to_string.
Characters in expr that are not in from_string are not replaced. If expr is a character string, then you must enclose it in single
quotation marks. The argument from_string can contain more characters than to_string. In this case, the extra characters at the
end of from_string have no corresponding characters in to_string. If these extra characters appear in char, then they are removed
from the return value.
You cannot use an empty string for to_string to remove all characters in from_string from the return value. Oracle Database
interprets the empty string as null, and if this function has a null argument, then it returns null.
TRANSLATE provides functionality related to that provided by the REPLACE function


相关文档:

Linux(Centos5.4)上安装oracle10gR2(10.2.1)

http://www.puschitz.com/InstallingOracle10g.shtml
我用的是Centos5.4
DVD光盘安装的linux操作系统,安装linux的时候选上开发工具,Xmanager,与数据库相关的包。
操作系统安装完成之后需要进行一系列的配置才能安装oracle10g,下面把
主要步骤记录下来。
1.安装完操作系统之后还是有些包没有安装,然而安装oracle10 ......

oracle RAC同步频率设置

max_commit_propagation_delay默认值为700,即7秒(单位0.01s,http://www.orafaq.com/parms/parm1217.htm)。
这个参数应该配置的是RAC(Real Application Cluster)之间同步数据的频率。修改这个参数的好处就不用说了(
本人深受其苦啊
),但是如果走另一个极端,可能会给数据库造成更大的压力
参数指定一个instance ......

如何高效删除Oracle数据库中的重复数据

Oracle 数据集成解决方案
  Oracle数据集成解决方案用于在SOA、BI和数据仓库环境中构建、部署和管理以实时数据为中心的架构,包含了数据集成的所有要素——实时数据移动、转换、同步、数据质量、数据管理和数据服务——能确保各个复杂系统的信息及时、准确、一致。
  通过使用Oracle数据集成,企 ......

.bat启动数据库服务(MSSQL,Oracle)

 @echo off
:dosmenu
REM 选择菜单
echo  Windows 服务启动或关闭 By hope 2008年2月7日     
echo.
echo [1]启动Sql Server2005   [2]关闭Sql Server2005
echo [3]启动Oracle9i         [4]关闭Oracle9i
echo.
echo  ......

Oracle解锁以及常用基本操作

-----------------------------------------------------------------------------------
DOS:
1. sqlplus
2.
   用户名:sqlplus 、conn
   密码:as sysdba 、as sysdba  
解锁:
3. ALTER USER DBSNMP ACCOUNT UNLOCK;
解锁:system
4. alter user system identified by manage ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号