Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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       


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

oracle weblogic v10.3 configure JNDI

Step 1: log on admin portal
Step 2: select menu 'Services' - 'JDBC' - 'Data Source' and click New button to create a new data source
Step 3 : specify jndi name ad database
Step 4 : click Next button to set transaction properties
Step 5 : define connection properties
 
Step 6 : test databa ......

oracle create tablespace

ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä.
·ÖÅä´æ´¢£¬¾ÍÒª´´½¨±í¿Õ¼ä£º¡¡¡¡
´´½¨±í¿Õ¼äÊ ......

OracleµÄschema,user

ÎÒÃÇÏÈÀ´¿´Ò»ÏÂËûÃǵ͍Ò壺
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 ......

oracleµÄTX lockÐÅÏ¢ÔÚÄÄÀ

ÎÒÃǶ¼ÖªµÀORACLE²»»á·¢ÉúËøÉý¼¶£¬Ëø¶ÔÓÚORACLEÀ´Ëµ²¢²»ÊÇϡȱ×ÊÔ´£¬ÎªÊ²Ã´DML lock¶ÔÓÚORACLEÀ´Ëµ²»ÊÇϡȱ×ÊÔ´£¬ÏÂÃæÀ´Ñ°ÕҴ𰸡£
SQL> select * from emp where sal>2999;
EMPNO ENAME      JOB         MGR HIREDATE     ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ