Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£ºCLUSTER

±í´Ø£¨table   cluster)ÊÇÒ»¸öÊý¾Ý¿â¶ÔÏó£¬Ëü¿ÉÒÔ½«ÄÇЩ¾­³£ÔÚÏàͬÊý¾Ý¿éÖÐÒ»ÆðʹÓÃµÄ±í½øÐÐÎïÀí·Ö×é¡£µ±Äã´¦ÀíÄÇЩ¾­³£Á¬½ÓÔÚÒ»Æð½øÐвéѯµÄ±íʱ£¬±í´ØÊÇÌØ±ðÓÐЧµÄ¡£Ò»¸ö±í´Ø´æ´¢´Ø¼ü£¨ÓÃÓÚ½«±íÁ¬½Óµ½Ò»ÆðµÄÁУ©£¬ÒÔ¼°´Ø±íÖеÄÁÐÖµ¡£ÒòΪ´ØÖÐµÄ±í¶¼±»´¢´æÔÚÏàͬµÄÊý¾Ý¿â¿éÖУ¬ËùÒÔʹÓôع¤×÷ʱ£¬I/O²Ù×÷¾Í¼õÉÙÁË¡£
......

´ÓOracleÊý¾Ý¿âµ¼³ö±í½á¹¹µ½PD

1¡¢Ð½¨PDM.ÓÒ»÷Workspace->New->Free Model->Physical Data Model 
2¡¢Model nameÈÎÒâ, DBMS=>ORACLE Version 9i2->È·¶¨
3¡¢ÅäÖÃODBC
¿ØÖÆÃæ°å->¹ÜÀí¹¤¾ß->Êý¾ÝÔ´(ODBC)->ϵͳDSN->Ìí¼Ó,Èç¹ûÓÐ×°ÍêÕûµÄOracle¿Í»§¶Ë»á³öÏÖרÃŵÄÇý¶¯,ÎÒµÄÊǼò°æµÄ¾ÍÑ¡
"Microsoft ODBC for Oracl ......

OracleÈÕÆÚº¯Êý¼¯½õ(Èý)

OracleÈÕÆÚº¯Êý¼¯½õ(Èý)
Èý¡¢Ò»Ð©Êµ¼ùºóµÄÓ÷¨£º
1.ÉÏÔÂÄ©Ì죺
select to_char(add_months(last_day(sysdate),-1),'yyyy-MM-dd') LastDay from dual£»
2.ÉÏÔ½ñÌì
SQL> select to_char(add_months(sysdate,-1),'yyyy-MM-dd') PreToday from dual;
3.ÉÏÔÂÊ×Ìì
SQL> select to_char(add_months(last_day(sysdate ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ