oracleÖÐÅжÏÒ»¸ö×Ö·û´®ÊÇ·ñÈ«²¿ÎªÊý×ֵĺ¯Êý
參¿¼:http://blog.csdn.net/rainnyzhong/archive/2009/01/09/3740660.aspx
×÷ÕߣºRainny
ÈÕÆÚ£º2009-1-8
´´½¨²âÊÔ±í£º
create table test(c_id varchar2(20));
²åÈë²âÊÔÊý¾Ý£º
insert into test values ('1234');
insert into test values ('45678');
insert into test values ('-1234');
insert into test values ('0.1234');
insert into test values ('-0.1234');
insert into test values ('abc');
insert into test values ('a9c');
insert into test values ('-a9c');
insert into test values ('-.a9c');
insert into test values ('-.');
insert into test values ('-');
insert into test values ('.');
--
ʹÓÃTRANSLATEº¯ÊýʵÏÖ£º
select * from test
where length(translate(c_id,'-.0123456789'||c_id,'-.0123456789'))=length(c_id)
and c_id not in ('-','-.','.')
ÎÒÃÇÀ´½âÊÍÒ»ÏÂtranslateº¯Êý¡£
translateº¯ÊýºÍreplaceº¯ÊýµÄ¹¦ÄÜÏàËÆ£¬Çø±ðÊÇtranslateÊÇÒÔ×Ö·û¼¶½øÐÐÌæ»»²Ù×÷£¬¶øreplaceº¯ÊýÔòÊÇÒÔ×Ö·û´®¼¶(¼´Õû¸ö×Ö·û´®ÍêÈ«Æ¥Åä²Å½øÐÐÌæ»»)½øÐÐÌæ»»²Ù×÷£º
SQL> select replace('abcdef','abe','123') from dual;
REPLACE('ABCDEF','ABE','123')
-----------------------------
abcdef
SQL> select translate('abcdef','abe','123') from dual;
TRANSLATE('ABCDEF','ABE','123'
------------------------------
12cd3f
SQL>
Translateº¯ÊýµÄÓï·¨£º
translate(char,from_string,to_string)
----------------------------------------------------------------------------------------------------------------------------------------------------------
²ÎÊý ˵Ã÷
----------------------------------------------------------------------------------------------------------------------------------------------------------
char ÊÇÐèÒª½øÐÐÌæ»»µÄ×Ö·û´®¡£
from_string
Ïà¹ØÎĵµ£º
¼Ì9Ô·ݹúÄÚijÖØÒªITÃÅ»§ÍøÕ¾±¬³ö¡¶520ÍòOracle ERPÏîĿʧ°ÜÖ®ÃÕ¡·µÄ“Ìì¼Û·ç²¨”Ö®ºó£¬11Ô·ݣ¬¹úÄÚijӰÏì×î´óµÄITרҵƽýÔÙ±¬¡¶¼×¹ÇÎÄÅöײ±ùɽ£º²¢¹ºSun½øÍËÁ½ÄÑ¡·¡£Á½Æª±¨µÀ´Ó²»Í¬½Ç¶È½Ò¶ÁËOracleÔÚÖйúµÄ¼Û¸ñ“Òþ˽”¡¢ÇþµÀÂÒÏ󡢿ͻ§Á÷ʧµÈ¾½Ïà¡£×ÅʵÈÃOracleÖйú¹«Ë¾µÄ¹«¹ØÃÇæ»îÁ˺ÃÒ ......
ÎÒÃÇÏÈÀ´¿´Ò»ÏÂËûÃǵĶ¨Ò壺
A schema is a collection of database objects (used by a user.).
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in the database that can connect to and access objects.
Schemas and users help database ......
½«BLOB±£´æΪ±¾µØÎĵµ£º
/// <summary>
/// ¶Á³öBlob×Ö¶Î
/// </summary>
/// <param name="commandText">sqlÓï¾ä£¬Ö´Ðнá¹ûΪBLOBÊý¾Ý</param>
/// <param name="DocumentAddress">½«Òª°ÑBLOBÊý¾Ý±£´æΪµÄÎĵµµÄ·¾¶</param>
......
CREATE TABLE T_BI_CurrentAccountDetailed
(
OrderDate DATE,
BranchFlag varchar2(3),
SortId varchar2(11),
OrderNo&n ......