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

ORACLEÖÐËÑË÷×ÖĸÊý×Ö»ìºÏµÄ×Ö·û´®

SQL> with tt as
  2  (
  3  select 'haha' string from dual union
  4  select '123' from dual union
  5  select 'haha12' from dual union
  6  select 'haha[]' from dual union
  7  select '12@@' from dual union
  8  select 'ah@!123' from dual
  9  )
 10  select string
 11  from
 12  (
 13  select string,translate(
 14  string,'abcdefghijklmnopqrstuvwxyz0987654321',
 15  rpad('#',26,'#')||rpad('*',10,'*')
 16  )
 17  translated from tt
 18  )
 19  where instr(translated,'#') > 0
 20  and instr(translated,'*') > 0;
STRING
-------
ah@!123
haha12
Æäʵ¾ÍÊÇͨ¹ýtranslateº¯Êý°ÑËùÓÐ×ÖĸºÍÊý×ֱ任³ÉÁ½ÖÖͳһµÄ×Ö·û£¬ÉÏÀýÖÐÊǰÑ×Öĸ±äΪ#£¬Êý×Ö±äΪ*£¬½Ó×ÅÔÙÍâ²ãselectµÄwhere×Ó¾äÖжÔת»»ºóµÄ×Ö·û´®½øÐÐÅжϣ¬Èç¹ûÁ½Õß¶¼´óÓÚ0£¬Ò²¾Í˵¼ÈÓÐ×ÖĸҲÓÐÊý×Ö£¬ÄÇô¾ÍûÎÊÌâÁË¡£


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle+jspÖÐblobÀàÐÍ´æ´¢´óÎı¾ÎÊÌâ½â¾ö·½·¨


 
 
 
 
 
oracle+jspÖÐblobÀàÐÍ´æ´¢´óÎı¾ÎÊÌâ½â¾ö·½·¨
oracle ´æ´¢´óÎı¾Ò»Ö±ÊÇÒ»¸ö¼¬ÊÖµÄÎÊÌâ¡£
Ò»¡¢´æÊý¾Ý¿â£º
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
//¶¨Òå±äÁ¿
java.sql.Connection conn; //Êý¾ ......

Oracle DBV ¹¤¾ß ½éÉÜ


DBVERIFY¹¤¾ßµÄÖ÷ҪĿµÄÊÇΪÁ˼ì²éÊý¾ÝÎļþµÄÎïÀí½á¹¹£¬°üÀ¨Êý¾ÝÎļþÊÇ·ñË𻵣¬ÊÇ·ñ´æÔÚÂß¼­»µ¿é£¬ÒÔ¼°Êý¾ÝÎļþÖаüº¬ºÎÖÖÀàÐ͵ÄÊý¾Ý¡£
DBVERIFY¹¤¾ß¿ÉÒÔÑéÖ¤ONLINE»òOFFLINEµÄÊý¾ÝÎļþ¡£²»¹ÜÊý¾Ý¿âÊÇ·ñ´ò¿ª£¬¶¼¿ÉÒÔ·ÃÎÊÊý¾ÝÎļþ¡£
 
1.¿ÉÒÔʹÓðïÖú²é¿´dbvµÄÃüÁî²ÎÊý
C:\>dbv help=y
DBVERIFY: Release 11. ......

ÔõôѡÔñÒ»¸ö¶ÔµÄOracle DBA

´ó²¿·ÖµÄÆóÒµºÜÄÑÒ»ÏÂ×Ó¾ÍÕÒµ½Ò»¸öÈ«·½Î»µÄOracle DBA£¨µ±È»Ò²ÊÇÓпÉÄÜ£¬Ö»²»¹ý£¬Õâ»áÓкܴóµÄÔËÆø³É·Ý£©£¬Õâ´ú±íÆóÒµÔÚÑ¡ÔñOracle DBAµÄʱºò£¬ÊƱØÒª¶Ô¸ºÔð¸ÃְλµÄDBAµÄÖ°ÄÜÓÐËùÈ¡Éá¡£ÎÒͨ³£»á½¨ÒéÎҵĿͻ§£¬ÔÚѰÕÒOracle DBAʱ£¬µÃÏÈÈ·ÈÏ£¬ÆóÒµÐèÒªÕâÒ»¸ö½ÇÉ«À´Æä´¦ÀíʲôÎÊÌ⣿
¡¡¡¡´ó²¿·ÝµÄÆóÒµ¶ÔOracle DBAµÄÐèÇó£¬Ò ......

Oracle 10g ĬÈϰ²×°´øÀ´µÄÓû§Ãû/ÃÜÂë


Oracle 10g ĬÈϰ²×°´øÀ´µÄÓû§Ãû/ÃÜÂë
 
Username
Password
Description
See Also
CTXSYS
CTXSYS
The Oracle Text account
Oracle Text Reference
DBSNMP
DBSNMP
The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database
Oracle Enter ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ