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

oracleѧϰ±Ê¼Ç(¶þ)·ÖÏíÖ®´æ´¢¹ý³ÌǶÌ×ÓαêÀý×Ó

create or replace procedure aa1 is
v_aa varchar2(20);
v_bb varchar2(20);
va_aa varchar2(20);
va_bb varchar2(20);
va_number_aa number;
message varchar2(60);
CURSOR aas is
SELECT DISTINCT aa.aa, aa.bb from aa;
CURSOR aaas is
SELECT DISTINCT aaa.aa, aaa.bb from aaa where aaa.aa = v_aa;
begin
OPEN aas;
FETCH aas INTO v_aa, v_bb;
WHILE aas%FOUND LOOP
OPEN aaas;
FETCH aaas INTO va_aa, va_bb;
WHILE aaas%FOUND LOOP
begin
va_number_aa :=to_number(va_bb);
exception
when others then
message:='ddddddddddddd';
end;

commit;
FETCH aaas INTO va_aa, va_bb;
END LOOP;
CLOSE aaas;
FETCH aas INTO v_aa, v_bb;
END LOOP;
CLOSE aas;
end aa1;

---------------------------------------------------
declare
v_id0000 char(2);
cursor c1 is select id00,name00 from a;
cursor c2 is select * from b where id0000=v_id0000;
begin
for i in c1 loop
v_id00:=i.id0000;
for j in c2 loop
null;
end loop;
end loop;
end;


Ïà¹ØÎĵµ£º

Oracle»¥»»×ܽá

Oracle»¥»»×ܽá
1. ¶àÐл»³ÉÒ»ÐÐ
    col1  col2            col1  col2
    a       1
    a       2     ת»»ºó ......

Oracle 10g Logminer Ñо¿¼°²âÊÔ

LogMinerÌṩÁËÒ»¸ö´¦ÀíÖØ×öÈÕÖ¾Îļþ²¢½«ÆäÄÚÈÝ·­Òë³É´ú±í¶ÔÊý¾Ý¿âµÄÂß¼­²Ù×÷µÄSQLÓï¾äµÄ¹ý³Ì¡£LogMinerÔËÐÐÔÚOracle°æ±¾8.1»òÕ߸ü¸ß°æ±¾ÖС£
 
 
Ò»£¬ÈçºÎʹÓÃLogminer:   
ÏÈÒª°²×°logminerµÄÁ½¸ö°ü£»ÒÔSYSÓû§ÔËÐÐÏÂÃæÁ½¸ö½Å±¾,ÆäÖеÚÒ»¸ö½Å±¾dbmslm.sqlÓÃÀ´´´½¨DBMS_LOGMNR°ü£¬¸Ã°üÓÃÀ´·Ö ......

windows ÏÂÃæoracle·þÎñÆ÷ instant clientµÄ°²×°

×ܵÄÀ´ËµwindowsÏÂÔØ°²×°oracleÈí¼þ±ÈlinuxÏÂÒª¼òµ¥µÄ¶à¡£
Ò».°²×°oracle ·þÎñ¶Ë
1.oracle·þÎñÆ÷µÄÏÂÔØÍøÖ·ÈçÏ£º
    http://www.oracle.com/technology/software/products/database/index.html
    È»ºóÎÒÑ¡ÔñÁËÏÂÃæÕâ¸ö°²×°°ü£º
    Oracle Database 10g Release 2 ( ......

ORACLE Êý¾Ý¿â×Ô¶¯±¸·Ý½Å±¾

#! /bin/bash
if  [ -f ~/.bashrc ];then
. ~/.bash_profile
fi
export script=/home/oracle/script
export bakdata_destination=/u02/rman_backup/data
export baklog_destination=/u02/rman_backup/log
export datadir=`date +'%Y_%m_%d'`
export days=`date +'%w'`
if ! test -d $script
then
 &nb ......

oracleÌØÊ⺯ÊýÓ÷¨

<< 1 >>
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·­ÒëÖµ1,Öµ2,·­ÒëÖµ2,...Öµn,·­ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·­ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ