Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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;


Ïà¹ØÎĵµ£º

hibernate.cfg.xml¹ØÁªOracleÊý¾Ý¿âµÄÅäÖÃ

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE hibernate-configuration (View Source for full doctype...)>
- <!-- Generated by MyEclipse Hibernate Tools.
--> - <!-- ÒÔÉϼ¸ÐÐËùÓеÄhibernate.cfg.xml¶¼Ïàͬ
--> [url=file:///C:/Documents%20and%20Settings/ ......

windowÏÂÃüÁîÐÐÆô¶¯oracle·þÎñ

windowÏÂÃüÁîÐÐÆô¶¯oracle·þÎñ
2008-11-12 22:30
Ò»¡¢¶ÀÁ¢Æô¶¯£º
Microsoft Windows 2000 [Version 5.00.2195]
(C) °æÈ¨ËùÓÐ 1985-2000 Microsoft Corp.
#########################################################
¼ì²é¼àÌýÆ÷״̬£º
#########################################################
E:">lsnrctl s ......

´«ÖDz¥¿Í 2010 1 19Ê®°Ë¡¢ORACLE(2)_ µ¥Ðк¯Êý


¶ÔÿһÐÐÊäÈëÖµ½øÐмÆË㣬µÃµ½ÏàÓ¦µÄ¼ÆËã½á¹û£¬·µ»Ø¸øÓû§£¬Ò²¾ÍÊÇ˵£¬Ã¿ÐÐ×÷Ϊһ¸öÊäÈë²ÎÊý£¬¾­¹ýº¯Êý¼ÆËãµÃµ½Ã¿ÐеļÆËã½á¹ûÊǵ¥Ðк¯Êý¡£
Ò»¡¢×Ö·ûº¯Êý
1¡¢×Ö·û´®´óСдת»»
(1)LOWER (strexp)    ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·ûСд
(2)UPPER (strexp)     ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ× ......

Oracle´æ´¢¹ý³ÌÓ﷨ѧϰ

´æ´¢¹ý³Ì´´½¨Óï·¨£º
 
£¨1£©ÎÞ²Î
create or replace procedure ´æ´¢¹ý³ÌÃû
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
       ........................
Exception
       ........................
End;
 
£¨2£©´ø ......

linux ÏÂoracle µÄ°²×°(·þÎñ¶ËºÍinstant client)

linux ϰ²×°oracle ÊÇÒ»¼þºÜÁîÈËÍ·ÌÛµÄÊÂÇ飬ÎÒ°Ñ×Ô¼ºµÄ°²×°²½ÖèÄóöÀ´¸ø´ó¼Ò·ÖÏíһϡ£
Ò».linux·þÎñ¶ËµÄ°²×°.
1.ÏÂÔØoracle·þÎñ¶ËÈí¼þ,ÏÂÔØÍøÖ·ÈçÏÂ
http://www.oracle.com/technology/software/products/database/index.html
ÎÒÑ¡ÔñµÄ°æ±¾ÊÇ£ºOracle Database 10g Release 2 (10.2.0.1.0) for Linux x86-64
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ