Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

javascriptÓñí¸ñÏÔʾʱ¼äÎÊÌâ

ÈçºÇÓÃjavascript´úÂë°ÑϵͳµÄʱ¼äÓÃÒ»¸ö1ÐÐ8Áеıí¸ñ¸øÏÔʾ³öÀ´
È磺


            µ±Ç°Ê±¼äÊÇ£º2009Äê  11Ô  1ÈÕ  ÐÇÆÚÈÕ  20ʱ  20·Ö  30Ãë


ÕâЩ¶¼ÊÇÔÚ±í¸ñÀïÃæÏÔʾµÄ
Ò»¸ñÏÔʾһ¸ö

ÊÇÒ»¸öÒ»ÐаËÁеıí¸ñ

лл ......

oracle ÖÐ like ×Ó¾äÎÊÌâ

ÊäÈëÈçÏÂÃüÁ
SQL> select tablespace_name,status,contents
  2  from dba_tablespaces;

TABLESPACE_NAME                STATUS    CONTENTS
------------------------------ --------- ---------
SYSTEM      &nbs ......

ÓüÇʱ¾²é¿´Oracle¿ØÖÆÎļþ

ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©

ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿

¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡

Ò»°ãÊý¾Ý¿âÖеÄËùÓпØÖÆÎļþÖеÄÄÚÈݶ¼ÊÇÒ»ÑùµÄ£¬²¢ÇÒËüÃÇ´æ´¢µÄ¶¼ÊǶþ½øÖƵÄÄÚÈÝÐÅÏ¢¡£ËùÒÔÄã¿´¼ûµÄÄÚÈݾÍÊÇÂÒ ......

oracleϵͳ×Ô´øµÄÁ·Ï°±íÓÐÄÄЩ£¬ÔõÑùÕÒ£¿

£¨1£©ÎÒ´ÓORACLEµÄÊéÉÏ¿´£¬ËµoracleÑù±¾Êý¾Ý¿âÖÐÓÐcustomers¡¢products¡¢salesºÍcostsÕâЩ±í¡£¿ÉÊÇÎÒÔÚÎÒµÄÊý¾Ý¿âÖÐÓÃ
¡°select * from tab;¡±ÕÒ²»µ½ÕâЩ±í°¡£¬ÇëÎÊÕâЩ±íÊÇÔÚÄĸöÕË»§Ï£¬Ôõô²ÅÄܵ÷Óõ½ÕâЩÁ·Ï°±íÄØ£¿ÎҵݲװµÄÊý¾Ý¿âÊÇ
oracle 10g 10.2.0 ×Ô½¨µÄÊý¾Ý¿âÃûÊÇ "demo"¡£
£¨2£©»¹ÓÐÎÒ´Ó±ð ......

Çë½ÌÒ»µÀOracleÀïµÄÕýÔò±í´ïʽÌâÄ¿

select
regexp_substr('AlxBB.W$Sn|Per','[^Ale|ax.r$]') sub
from dual
/

(ˇˍˇ£© Ï벻ͷͨ£¬ÒÔÉÏsqlÓï¾äµÄ½á¹ûÈçÏÂ

S
-
B

Çë¸ßÊִͽ̣¡£¡
SQL code:

select regexp_substr('AlxBB.W$Sn|Per','[^Ale|ax.r$]') sub from dual;
S
-
B


Ô ......

¹ØÓÚjavaµ÷ÓÃOracle²ÎÊýµÄÎÊÌâ

µ÷ÓÃOracleº¯ÊýµÄ´úÂ룺
Connection conn=null;
        CallableStatement stmt=null;
        try{
            conn=ei.getSession().connection();
            stmt=conn.prepareCall("{? ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [3606] [3607] [3608] [3609] 3610 [3611] [3612] [3613] [3614] [3615]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ