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

OracleµÄSOME,ANYºÍALL²Ù×÷

ƽʱºÜÉÙÓõÄÕ⼸¸ö²Ù×÷£¬½ñÌìÓöµ½ÁË¡£ÓÚÊÇÓÖ¿´ÁËÒ»ÏÂÎĵµ¡£
SOMEºÍANYÒ»Ñù£¬ÊDZȽϿíËɵģ¬ÀàËÆÓÚOR¡£Âú×ãÆäÖÐÈκÎÒ»¸ö¶¼¿ÉÒÔ¡£
ALLÒªÇóÑϸñһЩ£¬ÀàËÆÓÚAND£¬±ØÐëÈ«²¿Âú×ã²Å¿ÉÒÔ¡£
²»Äܵ¥¶ÀʹÓ㺠Must be preceded by =, !=, >, <, <=, >=.
Æäʵ¸üÓ¦¸Ã¹Ø×¢µÄÊǽô¸ú×ŵı¸×¢ÐÅÏ¢£¬Õâ¸öÒ»¿ªÊ¼±È½ÏÄÑÒÔÀí½â¡£
SOME (ANY)
Evaluates to FALSE if the query returns no rows.
ALL
Evaluates to TRUE if the query returns no rows.
×ö¸ö²âÊÔ°É¡£
ÏÈ¿´»ù±¾ÐÅÏ¢¡£
SQL> select max(salary) from employees;
 
MAX(SALARY)
-----------
      24000
 
SQL> select min(salary) from employees;
 
MIN(SALARY)
-----------
       2100
 
SQL> select count(1) from employees;
 
  COUNT(1)
----------
       107
 
SQL>
ÔÙÊÔÊÔ½á¹û¡£
SQL> SELECT count(1) from employees WHERE salary >= any (select 1 from dual where 1 < 1);
 
  COUNT(1)
----------
         0
 
SQL> SELECT count(1) from employees WHERE salary >= some (select 1 from dual where 1 < 1);
 
  COUNT(1)
----------
         0
 
SQL> SELECT count(1) from employees WHERE salary <= ALL (select 1 from dual where 1 < 1);
 
  COUNT(1)
----------
       107
 
SQL>


Ïà¹ØÎĵµ£º

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

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

Oracle10g r1ÔÚLINUX OS4Éϵݲװ

°²×°oralce10g R1(10.1)²½Öè·½·¨£º
µÚÒ»²¿·Ö£º
Ò».  Ó²¼þ»·¾³£º
   1. RAM£ºÖÁÉÙ512M
    2.  ½»»»·ÖÇø´óСÖÁÉÙ1G£¨»òÕßÊÇÄÚÔÚµÄ2±¶£©
   3./tmpĿ¼ ÖÁÉÙÓÐ400M¿ÕÏпռä
   4. oracleÈí¼þ°²×°¿Õ¼äÖÁÉÙÔÚ1.5G--3GÖ®¼ä£¨ÒÀ¾Ý°²×°oracleÀàÐͶø¶¨£©
 &nbs ......

oracle sequenceÖµÖØÖûØ1

declare 
  n   number(10); 
  tsql   varchar2(100); 
  begin 
  select   test_seq.nextval   into   n   from   dual; 
  n:=-(n-1); 
  tsql:='alter   ......

Oracle ÕʺŻù±¾¹ÜÀí

1. Oracle°²×°Íê³ÉºóµÄÓû§ÃûºÍÃÜÂë
sys/change_on_install
system/manager
scott/tiger
sysman/oem_temp
internal/oracle
 
2.ÐÞ¸ÄÓû§µÄÃÜÂë
SQL> conn sys/change_on_install as sysdba
Connected.
SQL> alter user sys identified by ******;
User altered.
 
3.ΪÓû§½âËø
SQL> ......

Oracle Exception

BEGIN
¡¡¡¡SELECT ...
¡¡¡¡SELECT ...
¡¡¡¡SELECT ...
¡¡¡¡...
¡¡¡¡EXCEPTION
¡¡¡¡WHEN NO_DATA_FOUND THEN -- catches all ’no data found’ errors
¡¡¡¡
¡¡¡¡2¡¢Òì³£µÄ·ÖÀà
¡¡¡¡
¡¡¡¡ÓÐÁ½ÖÖÀàÐ͵ÄÒì³££¬Ò»ÖÖΪÄÚ²¿Òì³££¬Ò»ÖÖΪÓû§×Ô¶¨ÒåÒì³££¬ÄÚ²¿Òì³£ÊÇÖ´ÐÐÆÚ¼ä·µ»Øµ½PL/SQL¿éµÄORACLE´íÎó»òÓÉPL/ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ