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

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 into ok values(vempno,vename);
end if;
end loop;
dbms_output.put_line('I Found You!'||mycur%rowcount||'ÐÐ');
close mycur;
end getok;
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/lixianzhang0493/archive/2009/12/31/5109682.aspx


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

Oracle DropÃüÁî

--ɾ³ý¿ÕµÄ±í¿Õ¼ä£¬µ«ÊDz»°üº¬ÎïÀíÎļþ
drop tablespace tablespace_name;
--ɾ³ý·Ç¿Õ±í¿Õ¼ä£¬µ«ÊDz»°üº¬ÎïÀíÎļþ
drop tablespace tablespace_name including contents;
--ɾ³ý¿Õ±í¿Õ¼ä£¬°üº¬ÎïÀíÎļþ
drop tablespace tablespace_name including datafiles;
--ɾ³ý·Ç¿Õ±í¿Õ¼ä£¬°üº¬ÎïÀíÎļþ
drop tablespace table ......

OracleÖÐɾ³ý°üº¬ÎﻯÊÓͼµÄ±í¿Õ¼äµÄ·½·¨


½ñÌìɾ³ýµÄ±í¿Õ¼ä°üº¬ÎﻯÊÓͼ±¨´í£¬ORA-23515: ʵÌ廯ÊÓͼºÍ/»òËüÃǵÄË÷Òý´æÔÚÓÚ±í¿Õ¼äÖÐ
¿´À´ÊÇÐèҪɾ³ýÎﻯÊÓͼ£¬Ö´ÐÐɾ³ý²Ù×÷£¬ÒòΪÊý¾ÝÌ«´óÁË£¬°ëÌìҲûŪÍ꣬ȡÏûÁË£¬ÉÏÍø²éÁíÍâÒ»ÖÖ·½·¨£¬É¾³ýÓû§£¬Ö¸¶¨cascade ²ÎÊý£¬ÕâÑù¾Í¿ÉÒÔÁË
ÎÒÊÔÁËһϸоõÓÃ
drop user user_name cascade;
ɾ³ýµÄ»¹ÊÇͦ¿ìµÄ£¬±Èɾ³ýÎï ......

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


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

Oracle»ù´¡ÊÔÌâ£¨ÃæÊÔ»ù±¾£©

1¡¢´æ´¢¹ý³ÌºÍº¯ÊýµÄÇø±ð¡£
£¨1£©¡¢´æ´¢¹ý³ÌÊÇ×÷ΪPL/SQLÓï¾äÖ´ÐУ¬¶øº¯ÊýÊÇ×÷Ϊ±í´ïʽµÄÒ»²¿·Öµ÷Óã»
 £¨2£©¡¢´æ´¢¹ý³ÌÔÚ¹æ¸ñ˵Ã÷Öв»°üº¬returnÓï¾ä£¬¶øÔÚº¯ÊýµÄ¹æ¸ñ˵Ã÷Õâ°üº¬return×Ӿ䣻
  (3)¡¢´æ´¢¹ý³Ì²»·µ»ØÖµ£¬¶øº¯Êý±ØÐë·µ»ØÖµ£»
 £¨4£©¡¢ÔÚ´æ´¢¹ý³ÌÖпÉÒÔ°üº¬returnÓï¾ä£¬µ«²»·µ»ØÈκÎÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ