Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£¬Ò²¾Í˵¼ÈÓÐ×ÖĸҲÓÐÊý×Ö£¬ÄÇô¾ÍûÎÊÌâÁË¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

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

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

Oracle DBV ¹¤¾ß ½éÉÜ


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

ÀûÓÃTOADʵÏÖEXCELÊý¾ÝÔÚoracleµÄµ¼Èëµ¼³ö


ÀûÓÃTOADʵÏÖEXCELÊý¾ÝÔÚoracleµÄµ¼Èëµ¼³ö
1.´ÓORACLEÊý¾Ý¿âµ¼³ö³ÉΪEXCELÎļþ
ÀûÓÃTOADÁ¬½ÓÉÏÊý¾Ý¿â£¬·ÃÎÊij¸ö±í£¬ÎÒ±¾»úÊÇÑ¡Öбí“OA_USER”
ÓÒ¼ü“Save as...”
ΪÁ˽â¾öÖÐÎÄÂÒÂëÎÊÌ⣬ËùÒÔÑ¡ÔñÀàÐÍΪ"XLS Instance"£¬Èç¹û´æÔÚ³¤Êý×ÖÐÍ×Ö·û´®±»¸Ä±äµÄÎÊÌ⣬
ÇëÑ¡ÖГString Fields as S ......

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ºÅ