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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ǰÌìÓÐÈËÌáÁËÐèÇó£¬Ïë¶Ôij¸ö×ֶνøÐа´Î»µÄ»ò²Ù×÷¡£±¾À´½¨Òé²éѯ³öÀ´Ö®ºóÔÚÓ¦ÓóÌÐòÀïÃæ´¦Àí£¬µ«ÊÇÊý¾ÝÁ¿±È½Ï´ó£¬¾õµÃ»¹ÊÇ·µ»ØÒ»¸ö·Ö×鼯ËãÖ®ºóµÄÖµ±È½ÏºÏÊÊ¡£
Á½¸öÎÊÌ⣬һ¸öÊǰ´Îª»òµÄ²Ù×÷£¬Õâ¸ö²Î¿¼Á˱ðÈ˵ÄÎĵµ£¬ÓÃbitandº¯ÊýʵÏÖ¡£ ÔÎÄÈçÏ£º
http://blog.chinahr.com/blog/hewy0526/post/112968
È»ºó¾ÍÊÇ×Ô¶¨ÒåµÄ ......
Ê×ÏȲ鿴Êý¾Ý¿âÏÖÓÐģʽ¿ÉʹÓÃÒÔÏÂÓï¾ä
select name,log_mode from v$database;
Ò²¿ÉÒÔÓÃÏÂÃæµÄÓï¾ä
archive log list£»(¸Ã·½·¨ÐèÒªas sysdba)
SQL> archive log list
Database log mode ¡¡¡¡¡¡¡¡¡¡¡¡No Archive Mode
Automatic archival¡¡¡¡¡¡¡¡¡¡¡¡Disabled
Archive destination¡¡¡¡¡¡¡¡¡¡ /export/home ......
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> ......