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


Ïà¹ØÎĵµ£º

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¶¨Ê±Ö´Ðд洢¹ý³ÌµÄjob

±¾ÎÄ×ªÔØ:http://blog.csdn.net/flm_0722/archive/2009/10/08/4643566.aspx
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
......

Oracle ÒÆ¶¯Êý¾ÝÎļþµÄ²Ù×÷·½·¨

½«±í¿Õ¼äºÍÊý¾ÝÎļþ´ÓÒ»¸öλÖÃÒÆ¶¯µ½ÁíÒ»¸öλÖõIJÙ×÷·½·¨
Ò»£® OFFLINE
OFFLINE ·ÖΪALTER DATABASE Óë ALTER TABLESPACE OFFLINE£¬
ËûÃǵÄÇø±ð²Î¿´blog£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/29/4898800.aspx
°´Êý¾ÝÎļþÀ´£º
1.ÏȽ«ÏàÓ¦µÄÊý¾ÝÎļþ offline 
ALTER DATABASE DATAFILE 'D:\OR ......

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 ¿ØÖÆÎļþ

Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECORD ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ