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

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Èý)

 1.¶à°æ±¾£º¶ÁÒ»Ö²éѯ  ·Ç×èÈû²éѯ
Oracle ²ÉÓÃÁËÒ»ÖÖ
¶à°æ±¾¡¢¶ÁÒ»Ö£¨read-consistent£©µÄ²¢·¢Ä£ÐÍ¡£ÔÙ´Î˵Ã÷£¬ÎÒÃǽ«ÔÚµÚ7 Õ¸üÏêϸµØ½éÉÜÓйصļ¼Êõ¡£
²»¹ý£¬ÊµÖÊÉϽ²£¬Oracle ÀûÓÃÕâÖÖ»úÖÆÌṩÁËÒÔÏÂÌØÐÔ£º
¶ÁÒ»Ö²éѯ£º¶ÔÓÚÒ»¸öʱ¼äµã£¨point in time£©£¬²éѯ»á²úÉúÒ»ÖµĽá¹û¡£
·Ç×èÈû²éѯ£º²éѯ²»»á±»Ð´ÈëÆ÷×èÈû£¬µ«ÔÚÆäËûÊý¾Ý¿âÖпÉÄܲ»ÊÇÕâÑù¡£
Oracle Êý¾Ý¿âÖÐÓÐÁ½¸ö·Ç³£ÖØÒªµÄ¸ÅÄî¡£¶à°æ±¾£¨multi-versioning£©Ò»´ÊʵÖÊÉÏÖ¸Oracle Äܹ»´Ó
Êý¾Ý¿âͬʱÎﻯ¶à¸ö°æ±¾µÄÊý¾Ý¡£Èç¹ûÄãÀí½âÁË¶à°æ±¾ÈçºÎ¹¤×÷£¬¾Í»áÖªµÀÄÜ´ÓÊý¾Ý¿âµÃµ½Ê²Ã´¡£ÔÚ½øÒ»
²½ÉîÈëÌÖÂÛOracle ÈçºÎʵÏÖ¶à°æ±¾Ö®Ç°£¬ÏÂÃæÓÃÎÒÈÏΪ×î¼òµ¥µÄÒ»¸ö·½·¨À´ÑÝʾOracle ÖÐµÄ¶à°æ±¾£º
( p_resource_name, p_start_time, p_end_time );
end schedule_resources;
ops$tkyte@ORA10G> create table t
2 as
3 select *
4 from all_users;
Table created.
ops$tkyte@ORA10G> variable x refcursor
ops$tkyte@ORA10G> begin
2 open :x for select * from t;
3 end;
4 /
PL/SQL procedure successfully completed.
ops$tkyte@ORA10G> delete from t;
28 rows deleted.
ops$tkyte@ORA10G> commit;
Commit complete.
ops$tkyte@ORA10G> print x
USERNAME USER_ID CREATED
------------------------------ -------------- ---------------
BIG_TABLE 411 14-NOV-04
OPS$TKYTE 410 14-NOV-04
DIY 69 26-SEP-04
...
OUTLN 11 21-JAN-04
SYSTEM 5 21-JAN-04
ÔÚÇ°ÃæµÄÀý×ÓÖУ¬ÎÒ´´½¨ÁËÒ»¸ö²âÊÔ±íT£¬²¢°ÑALL_USERS ±íµÄһЩÊý¾Ý¼ÓÔØµ½Õâ¸ö±íÖС£È»ºóÔÚÕâ
¸ö±íÉÏ´ò¿ªÒ»¸öÓαꡣÔÚ´ËûÓдӸÃÓαê»ñÈ¡Êý¾Ý£¬Ö»ÊÇ´ò¿ªÓÎ±ê¶øÒÑ¡£
×¢ÒâÒª¼Çס£¬Oracle ²¢²»“»Ø´ð”Õâ¸ö²éѯ¡£´ò¿ªÓαêʱ£¬Oracle ²»¸´ÖÆÈκÎÊý¾Ý£¬Äã¿ÉÒÔÏëÏë¿´£¬
¼´Ê¹Ò»¸ö±íÓÐÊ®ÒÚÌõ¼Ç¼£¬ÊDz»ÊÇÒ²Äܺܿì¾Í´ò¿ªÓαꣿû´í£¬Óαê»áÁ¢¼´´ò¿ª£¬Ëü»á±ßÐнø±ß
»Ø´ð²éѯ¡£»»¾ä»°Ëµ£¬Ö»ÊÇÔÚÄã»ñÈ¡Êý¾ÝʱËü²Å´Ó±íÖжÁÊý¾Ý¡£
ÔÚͬһ¸ö»á»°ÖУ¨»òÕßÒ²¿ÉÒÔÔÚÁíÒ»¸ö»á»°ÖУ»ÕâͬÑùÄܺܺõع¤×÷£©£¬ÔٴӸñíɾ³ýËùÓÐÊý¾Ý¡£Éõ
ÖÁÓÃCOMMIT Ìá½»ÁËɾ³ýËù×öµÄ¹¤×÷¡£¼Ç¼Ðж¼Ã»ÓÐÁË£¬µ«ÊÇÕæµÄûÓÐÁËÂð£¿Êµ¼ÊÉÏ£¬»¹ÊÇ¿ÉÒÔͨ¹ýÓαê»ñ
È¡µ½Êý¾Ý¡£OPEN ÃüÁî·µ»ØµÄ½á¹û¼¯ÔÚ´ò¿ªµÄÄÇÒ»¿Ì£¨Ê±¼äµã£©¾ÍÒѾ­È·¶¨¡£´ò¿ªÊ±£¬ÎÒÃǸù±¾Ã»ÓÐÅö¹ý±í
ÖеÄÈκÎÊý¾Ý¿é£¬µ«´ð°¸ÒѾ­ÊÇÌú°å¶¤¶¤µÄÁË


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLEÖÐÒ»¸öUPDATEµÄ²Ù×÷Á÷³Ì

ǰÕó×Ó¿´µ½Ò»Æª¹ØÓÚDELETE²Ù×÷µÄ¾ßÌåµÄÁ÷³Ì£¬½ñÌìÎÞÒâ¼äÓÖ¿´µ½Ò»¸öUPDATEµÄ²Ù×÷Á÷³Ì£¬Í¦ÓÐȤµÄ£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°£¡
================================================================================
1£¬Óû§Ìá½»Ò»¸öupdateÓï¾ä
2£¬server process¼ì²éÄڴ滺´æ
      i Èç¹ûûÓÐÓÐЧÄÚ´æ¿Õ¼ ......

oracle ÖеÄIN£¬LIke

 INÌõ¼þ
ÓÃINÌõ¼þÔÚÖ¸¶¨µÄÒ»×éÖµÖнøÐвâÊÔ¡£INÌõ¼þÒ²¾ÍÊÇ ³ÉÔ±Ìõ¼þ¡£
ÔÚ»ÃµÆÆ¬µÄÀý×ÓÖÐÏÔʾËùÓо­ÀíºÅΪ100¡¢101»ò201µÄ¹ÍÔ±µÄemployee numbers, last names, salariesºÍ¾­ÀíµÄemployee numbers¡£
ÔÚINÌõ¼þÖпÉÒÔʹÓÃÈκÎÊý¾ÝÀàÐÍ¡£ÏÂÃæµÄÀý×Ó´ÓEMPLOYEES±í·µ»Ø¹ÍÔ±ÐÅÏ¢ÐУ¬ÕâЩ¹ÍÔ±µÄÃû×Ö°üÀ¨ÔÚWHERE×Ó¾äµÄÃû×ÖÁÐ ......

Oracle ×î³£Óù¦Äܺ¯Êý¾­µä»ã×Ü

¡¡¡¡* SQL Group Function
*
s (num can be a column or ex
pression)¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
¡¡¡¡(null values are ign
*
ored, default between distin
ct and all is all)¡¡¡¡¡¡¡¡¡¡¡¡
¡¡¡¡********************
***************
****************************
****************
¡¡¡¡AVG([distinct or all ......

Oracle SQL*LoaderÊý¾Ý×°ÔØ

SQL*Loader ÓÃÓÚ½«´óÁ¿Êý¾Ý×°ÈëÊý¾Ý¿â¡£
¢Å¡¢¶¨¿íÊý¾Ý
´´½¨Êý¾ÝÎļþcontrol.txt£º
aaa,bbb
ccc,ddd
eee,fff
´´½¨¿ØÖÆÎļþcontrol.ctl£º
load data
infile 'c:\loader.txt'
append
into table tester.mm(
m1 position(1:3) char,
m2 position(5:7) char)
ÅúÁ¿¼ÓÔØÊý¾Ý£º
sqlldr tester/test control=c:\loade ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ