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

oracleÖÐselect 1ºÍselect *µÄÇø±ð

´´½¨myt±í²¢²åÈëÊý¾Ý£¬ÈçÏ£º
create table myt(name varchar2,create_time date)
 insert into myt values('john',to_date(sysdate,'DD-MON-YY'));
 insert into myt values('tom',to_date(sysdate,'DD-MON-YY'));
 insert into myt values('lili',to_date(sysdate,'DD-MON-YY'));  
 ÔÚsql*plusÖÐÏÔʾÈçÏ£º
SQL> select * from myt;
 
NAME       CREATE_TIME
---------- -----------
john       2010-5-19
tom        2010-5-19
lili       2010-5-19
 
SQL> select 1 from myt;
 
         1
----------
         1
         1
         1
SQL> select 0 from myt;
 
         0
----------
         0
         0
         0
´ÓÒÔÉϽá¹û ¿ÉÒÔ¿´µ½£¬select constant fromtable ¶ÔËùÓÐÐзµ»Ø¶ÔÓ¦µÄ³£Á¿Öµ£¨¾ßÌåÓ¦ÓüûÏÂÃæ£©£¬
¶øselect * from tableÔò·µ»ØËùÓÐÐжÔÓ¦µÄËùÓÐÁС£
select 1³£ÓÃÔÚexists×Ó¾äÖУ¬¼ì²â·ûºÏÌõ¼þ¼Ç¼ÊÇ·ñ´æÔÚ¡£
Èçselect * from T1 where exists(select 1 from T2 where T1.a=T2.a) ;
T1Êý¾ÝÁ¿Ð¡¶øT2Êý¾ÝÁ¿·Ç³£´óʱ£¬T1<<T2 ʱ£¬1) µÄ²éѯЧÂʸߡ£
“select 1”ÕâÀïµÄ “1”ÆäʵÊÇÎ޹ؽôÒªµÄ£¬»»³É“*”ҲûÎÊÌ⣬ËüÖ»ÔÚºõÀ¨ºÅÀïµÄÊý¾ÝÄܲ»ÄܲéÕÒ³öÀ´£¬ÊÇ·ñ´æÔÚÕâÑùµÄ¼Ç¼£¬Èç¹û´æÔÚwhere Ìõ¼þ³ÉÁ¢¡£
ÈçÏÂʾÀý£º
SQL> select 1/0 from dual;
 
select 1/0 from dual
 
ORA-01476: ³ýÊýΪ 0
SQL> select * from myt where  exists(select 1/0 from dual);
 
NAME       CREATE_TIME
---------- -----------
john       2010-5-19
tom        2010-5-19
lili &nbs


Ïà¹ØÎĵµ£º

Oracleʱ¼äÀàÐÍÊý¾ÝΪ0µÄbug

Ó¦ÓÃÊý¾Ý¿âÖмǼÖÐdateÁÐĪÃûÆäÃîµÄ³öÏÖÁ˼¸¸öֵΪ0000-00-00µÄÊý¾Ý¡£
¸ü¿ÉŵÄÊÇÈç¹û½«ÕâÑùµÄ¼Ç¼½øÐжÁÈ¡³ÉΪvarchar2ºóÔÙto_dateת»»»ØÈ¥¾Í»á±¨´í¡£
ÎÊÌâÎÞ´Ó²éÆð£¬Ö»ËµÒ»ÏÂ×îÖÕͬÊÂËÑË÷µ½µÄÁ¬½Ó½á¹û£ºhttp://www.hellodba.com/Doc/oracle_date_zero_bug.htm
¿´À´µÄÈ·ÊÇoracleµÄÒ»¸öbug¡£
ÁíÍâÐèҪעÒâµÄÊÇ£¬ÔÚʹÓà ......

Oracle Logminer

LogminerÊÇoracle´Ó8i¿ªÊ¼ÌṩµÄÓÃÓÚ·ÖÎöÖØ×öÈÕÖ¾ÐÅÏ¢µÄ¹¤¾ß£¬Ëü°üÀ¨DBMS_LOGMNRºÍDBMS_LOGMNR_DÁ½¸öpackage£¬ºó±ßµÄDÊÇ×ÖµäµÄÒâ˼¡£Ëü¼ÈÄÜ·ÖÎöredo log file£¬Ò²ÄÜ·ÖÎö¹éµµºóµÄarchive log file¡£ÔÚ·ÖÎöÈÕÖ¾µÄ¹ý³ÌÖÐÐèҪʹÓÃÊý¾Ý×ֵ䣬һ°ãÏÈÉú³ÉÊý¾Ý×ÖµäÎļþºóʹÓã¬10gÒÔºóµÄ°æ±¾»¹¿ÉÒÔʹÓÃÔÚÏßÊý¾Ý×ֵ䡣
Logminer¿ÉÒÔ ......

oracle²é¹ØÊ±¼ä²Ù×÷

Oracle¹ØÓÚʱ¼ä/ÈÕÆÚµÄ²Ù×÷
¡¡¡¡1.ÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7·ÖÖÓµÄʱ¼ä
¡¡¡¡Java´úÂë
select sysdate,sysdate - interval '7' MINUTE from dual 
select sysdate,sysdate - interval '7' MINUTE from dual
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7СʱµÄʱ¼ä
¡¡¡¡Java´úÂë
select sysdate - interval '7' hour fr ......

OracleÊý¾Ý¿âÃÜÂëÎļþÖÐÔö¼Ó¡¢É¾³ýÓû§£º

µ±³õʼ»¯²ÎÊýREMOTE_LOGIN_PASSWORDFILEÉèÖÃΪEXCLUSIVEʱ£¬ÏµÍ³ÔÊÐí³ýINTERNAL/SYSÒÔÍâµÄÆäËûÓû§ÒÔ¹ÜÀíÔ±Éí·Ý´ÓÔ¶¶Ë»ò±¾»úµÇ¼µ½OracleÊý¾Ý¿âϵͳ£¬Ö´ÐÐÊý¾Ý¿â¹ÜÀí¹¤×÷;ÕâЩÓû§Ãû±ØÐë´æÔÚÓÚÃÜÂëÎļþÖУ¬ÏµÍ³²ÅÄÜʶ±ðËûÃÇ¡£ÓÉÓÚ²»¹ÜÊÇÔÚ´´½¨Êý¾Ý¿âʵÀýʱ×Ô¶¯´´½¨µÄÃÜÂëÎļþ£¬»¹ÊÇʹÓù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨µÄÃÜÂëÎļþ£¬¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ