ÈçºÇÓÃjavascript´úÂë°ÑϵͳµÄʱ¼äÓÃÒ»¸ö1ÐÐ8Áеıí¸ñ¸øÏÔʾ³öÀ´
È磺
µ±Ç°Ê±¼äÊÇ£º2009Äê 11Ô 1ÈÕ ÐÇÆÚÈÕ 20ʱ 20·Ö 30Ãë
ÕâЩ¶¼ÊÇÔÚ±í¸ñÀïÃæÏÔʾµÄ
Ò»¸ñÏÔʾһ¸ö
ÊÇÒ»¸öÒ»ÐаËÁеıí¸ñ
лл ......
ÊäÈëÈçÏÂÃüÁ
SQL> select tablespace_name,status,contents
2 from dba_tablespaces;
TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
SYSTEM &nbs ......
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©
ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿
¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡
Ò»°ãÊý¾Ý¿âÖеÄËùÓпØÖÆÎļþÖеÄÄÚÈݶ¼ÊÇÒ»ÑùµÄ£¬²¢ÇÒËüÃÇ´æ´¢µÄ¶¼ÊǶþ½øÖƵÄÄÚÈÝÐÅÏ¢¡£ËùÒÔÄã¿´¼ûµÄÄÚÈݾÍÊÇÂÒ ......
£¨1£©ÎÒ´ÓORACLEµÄÊéÉÏ¿´£¬ËµoracleÑù±¾Êý¾Ý¿âÖÐÓÐcustomers¡¢products¡¢salesºÍcostsÕâЩ±í¡£¿ÉÊÇÎÒÔÚÎÒµÄÊý¾Ý¿âÖÐÓÃ
¡°select * from tab;¡±ÕÒ²»µ½ÕâЩ±í°¡£¬ÇëÎÊÕâЩ±íÊÇÔÚÄĸöÕË»§Ï£¬Ôõô²ÅÄܵ÷Óõ½ÕâЩÁ·Ï°±íÄØ£¿ÎҵݲװµÄÊý¾Ý¿âÊÇ
oracle 10g 10.2.0 ×Ô½¨µÄÊý¾Ý¿âÃûÊÇ "demo"¡£
£¨2£©»¹ÓÐÎÒ´Ó±ð ......
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
Ô ......
µ÷ÓÃOracleº¯ÊýµÄ´úÂ룺
Connection conn=null;
CallableStatement stmt=null;
try{
conn=ei.getSession().connection();
stmt=conn.prepareCall("{? ......