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
Ïà¹ØÎĵµ£º
Èç¹û²»ÊÇÒòΪÕâ´Î»»hisµÄ·þÎñÆ÷£¬¹À¼ÆÎÒÒ»Ö±Ò²²»»áÓöµ½Õâ¸öÎÊÌ⣬һֱ¾õµÃoracleºÜ¸ßÉ¶ÔËüҲûÓÐÑо¿£¬¿ÉÕâ´Î»»·þÎñÆ÷£¬Æ«Æ«ÈÃÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬ÕÛÄ¥ÁËÕûÕûÁ½Ì죬ÖÕÓÚÔÚ×òÌì½â¾öµôÁË£¬¼Ç¼ÏÂÀ´£¬ÒÔ±¸ÒÔºóËùÓá£
ÖÜÎåÍíÉÏ»»ÁË·þÎñÆ÷£¬ÖÜÒ»ÔçÉÏ·¢ÏÖ³¬ÉùµÄ¹¤×÷Õ ......
1. ÔÚoracle Ï´´½¨±í
t_user(
ID varchar(20),
Name varchar(20)
)
2. Ìí¼ÓÊý¾Ý
&nb ......
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 ......
Oracl Êý¾Ý¿âҲûÓиö°ë¶Î±íÊÇ·ñ´æÔÚ£¬´æÔÚÔòɾ³ýµÄÓï¾ä£¬¾¹ýÑо¿ºÍ¸ÄдËûÈ˵ķ½·¨ÏÈ¡ÖØÍƳö¾ø¶ÔÄÜÓÃÐÔµÄOracleÅжϱíÊÇ·ñ´æÔÚ£¬´æÔÚÔòɾ³ý·½·¨£¬ÔÚOracle10gÉÏÊÔÑéͨ¹ý¡£
·½·¨
CREATE OR REPLACE FUNCTION PROC_NAME(T_NAME IN VARCHAR2) RETURN NUMBER IS
V_CNT number;
V_SQL VARCHAR2(100);
......