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

oracle²¹¶¡ÏÂÔصØÖ·

oracle²¹¶¡ÏÂÔصØÖ·
DB   2009-10-28 18:00   ÔĶÁ56   ÆÀÂÛ0  
×ֺţº ´ó´ó  ÖÐÖР СС
Oracle 11g 11.1.0.7
ftp://updates.oracle.com/6890831/p6890831_111070_AIX5L_1of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_AIX5L_2of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-64_1of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-64_2of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-IA64_1of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-IA64_2of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_Linux-x86-64.zip
ftp://updates.oracle.com/6890831/p6890831_111070_Linux-x86.zip
ftp://updates.oracle.com/6890831/p6890831_111070_MSWIN-x86-64.zip
ftp://updates.oracle.com/6890831/p6890831_111070_SOLARIS64.zip
ftp://updates.oracle.com/6890831/p6890831_111070_Win32.zip
Oracle 10g 10.2.0.4
ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_AXP.zip
ftp://updates.oracle.com/6810189/p6810189_10204_BS2000.zip
ftp://updates.oracle.com/6810189/p6810189_10204_BS2000SX.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_IBMPower.zip
ftp://updates.oracle.com/6810189/p6810189_10204_ItaniumVMS.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-zSer.zip
ftp://updates.oracle.com/6810189/p6810189_10204_MSWIN-x86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solarisx86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip
Oracle 10g 10.2.0.3
ftp://upda


Ïà¹ØÎĵµ£º

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 ......

ÔÚOracleÊý¾Ý¿â´´½¨½Å±¾ÖÐÈçºÎ³õʼ»¯Ä³Ð©±í

Sample
±í¿Õ¼ä£ºIMPTEMP
±í£ºRoles ¡¢Users
ͨ¹ýPL/SQLµ¼³öµÄÊý¾Ý¿â½Å±¾
-----------------------------------------------------
-- Export file for user IMPTEMP                    --
-- Created by Administ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ