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

Ubuntu°²×°OracleºóÔËÐÐSqlplus±¨´íµÄ½â¾ö°ì·¨

µ±ÔËÐÐsqlplus.shµÄʱºò±¨³ö£º
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
ºÜÆæ¹Ö
nls_lang.shµÄ114ÐÐǰºóÊÇÕâÑùµÄ
if [[ -n "$LC_ALL" ]]; then
  locale=$LC_ALL
elif [[ -n "$LANG" ]]; then
  locale=$LANG
else
  locale=
fi
[[ÓдíÎ󣿲»¿ ......

OracleÒÆÖ²µ½MySQL×¢ÒâÊÂÏî

¡¡¡¡¿Í»§ÓõÄÊý¾Ý¿âÊÇmysql£¬¶øÑз¢ºÃµÄ²úÆ·Ö§³Öoracle£¬ÎªÁËÈÿͻ§ÌÍÑü°ü£¬ÎÒÃDZØÐë°ÑÊý¾Ý¿â»·¾³´ÓoracleתÏòmysql¡£ÎÒÃÇÔÚת»»µÄ¹ý³ÌÖÐÅöµ½ÁËÏÂÃæÒ»Ð©ÎÊÌ⣬ϣÍûÄܸøÍ¬ÑùÔâÓöµÄͬÈÊÃÇһЩ½è¼ø¡£Èç¹ûÎÒÃÇÔÚ×î³õµÄÉè¼Æ¡¢±àÂë¹ý³ÌÖÐ×¢ÒâÊý¾Ý¿âµÄÒÆÖ²ÐÔ£¬ÕâÖÖÇé¿öÏ¿ÉÒÔÍêÈ«²»ÐèÒª×÷¶îÍ⹤×÷¡£
¡¡¡¡Ò»¡¢Êý¾Ý¿â»·¾³´Óoracleת ......

Oracle Exception

BEGIN
¡¡¡¡SELECT ...
¡¡¡¡SELECT ...
¡¡¡¡SELECT ...
¡¡¡¡...
¡¡¡¡EXCEPTION
¡¡¡¡WHEN NO_DATA_FOUND THEN -- catches all ’no data found’ errors
¡¡¡¡
¡¡¡¡2¡¢Òì³£µÄ·ÖÀà
¡¡¡¡
¡¡¡¡ÓÐÁ½ÖÖÀàÐ͵ÄÒì³££¬Ò»ÖÖΪÄÚ²¿Òì³££¬Ò»ÖÖΪÓû§×Ô¶¨ÒåÒì³££¬ÄÚ²¿Òì³£ÊÇÖ´ÐÐÆÚ¼ä·µ»Øµ½PL/SQL¿éµÄORACLE´íÎó»òÓÉPL/ ......

OracleÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ

OracleÊý¾Ý¿âÌṩÁ˼¸ÖÖ²»Í¬µÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ·½Ê½£¬±¾ÎĽ«Ïêϸ½éÉÜÕâЩÆô¶¯ºÍ¹Ø±Õ·½Ê½Ö®¼äµÄÇø±ðÒÔ¼°ËüÃǸ÷×Ô²»Í¬µÄ¹¦ÄÜ¡£
Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â¡¡¡¡¶ÔÓÚ´ó¶àÊýOracle DBAÀ´Ëµ£¬Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â×î³£Óõķ½Ê½¾ÍÊÇÔÚÃüÁîÐз½Ê½ÏµÄServer Manager¡£´ÓOracle 8iÒÔºó£¬ÏµÍ³½«Server ManagerµÄËùÓй¦Äܶ¼¼¯Öе½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ