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

oracleɾ³ý±íÖÐËùÓеÄÊý¾Ý

ʾÀýÒ»£ºdelete from emp;
ʵÀý¶þ£ºtruncate table emp;
µ±Ê¹ÓÃdeleteɾ³ýʱ£¬ËäȻɾ³ýÁ˱íÖеÄËùÓÐÊý¾Ý£¬µ«ÊÇûÓÐÊͷűíËùÕ¼µÄ¿Õ¼ä£¬Èç¹ûÓû§È·¶¨ÒªÉ¾³ý±íÖÐËùÓÐÊý¾Ý£¬Ê¹ÓÃʵÀý¶þÓï¾äËٶȸü¿ì¡£deleteÓï¾ä¿ÉÒÔ»ØÍË£¬µ«truncateÓï¾ä²Ù×÷²»ÄÜ»ØÍË£¬Ö´ÐеÄʱºòÒª¶à¼Ó×¢ÒâÕâÒ»µã¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

win 7ϰ²×°oracle 10g£¨Ïêϸ¹ý³Ì£©

»ù±¾ÒªÇó
win 7µÄ°æ±¾ÊÇÆì½¢°æ£¬oracle 10g£¨Oracle10gµÚ2°æ10.2.0.3-10.2.0.410203vistaw2k8x86productiondb£©Ñ¸À×ÓÐÏÂÔØ
£¨ËÑË÷“oracle 10g vista”£¬760MB£©
¾ßÌå¹ý³Ì
1.ÅäÖÃÒ»¸öÐéÄâµÄIP£ºÔÚ°²×°ORACLE 10gǰϵͳ»á¼ì²â°²×°µÄһЩǰÌáÌõ¼þÊÇ·ñÂú×㣬
ÍùÍù»áÌáʾ˵£º½«Microsoft LoopBack AdapterÅäÖÃΪ ......

Oracle·¢²¼SunµÄ¸÷Ïî²úÆ·µÄδÀ´µÄFAQÁбí


Ô­·¢±íÓÚhttp://saharabear.javaeye.com
ͬʱ·¢±íÔÚÕâÀï.
²»ÐèÒªÏàÐÅÉÌÒµÉϵÄÈκγÐŵ,²»¹ýÈκεĹٷ½FAQ¶¼»áÓвο¼¼ÛÖµ,ÕâÀï
ÊÇOracle·¢²¼µÄÕë¶ÔSunµÄ¸÷Ïî²úÆ·µÄһЩ˵Ã÷µÄFAQ,»ù±¾ÉÏÃèÊöÁ˶ÔGlassfish¼ÌÐøÖ§³Ö,¶ÔNetbeans¼ÌÐø¿ª·¢µÄ̬¶È,²»¹ý,kenai.com,ΰ´óµÄ"ÎÒÃDz»½ö½öÊÇ´úÂëÍйÜ"µÄÉç½»ÐÔ¿ª·¢Õ¾µã,»ù± ......

OracleÅÅÐòÒÔ¼°ÐòºÅµÄÊä³ö

   ÔÚÒ»°ãSelectÓï¾äÖÐÎÒÃÇͨ¹ýOrder by ...Asc/DescÀ´½øÐÐÅÅÐò¡£µ«ÊÇÕâÖÖÅÅÐò·½Ê½ÔÚÊä³öʱ£¬²»°üº¬ÅÅÐòºóµÄÐòºÅÐÅÏ¢¡£
   ÏÖÔÚ½éÉÜÒ»ÏÂOracleÖпÉÒÔÓÃÓÚÅÅÐòÊä³öµÄ·½·¨¡£
   1. RANK ( ) OVER ( [query_partition_clause] order_by_clause )
   RANK ( ) OVER ( [query_p ......

Oracle Óαê Cursor ʹÓÃ

create or replace procedure getok
as
cursor mycur is select ids,name from aaa where name not in (select names from ok);
vempno aaa.ids%type;
vename aaa.name%type;
begin
open mycur;
loop
fetch mycur into vempno,vename;
exit when mycur%notfound;
if mycur%found then
    insert ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ