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

Oracle´æ´¢¹ý³Ì×ܽá(Ò»¡¢»ù±¾Ó¦ÓÃ)

1¡¢´´½¨´æ´¢¹ý³Ì
create or replace procedure test(var_name_1 in type,var_name_2 out type) as
--ÉùÃ÷±äÁ¿(±äÁ¿Ãû ±äÁ¿ÀàÐÍ)
begin
--´æ´¢¹ý³ÌµÄÖ´ÐÐÌå
end test;
´òÓ¡³öÊäÈëµÄʱ¼äÐÅÏ¢
E.g:
create or replace procedure test(workDate in Date) is
begin
dbms_output.putline('The input date is:'||to_date(workDate,'yyyy-mm-dd'));
end test;
2¡¢±äÁ¿¸³Öµ
±äÁ¿Ãû := Öµ;
E.g£º
create or replace procedure test(workDate in Date) is
x number(4,2);
 begin
 x := 1;
end test;
3¡¢ÅжÏÓï¾ä:
if ±È½Ïʽ then begin end; end if;
E.g
create or replace procedure test(x in number) is
begin
        if x >0 then
         begin
        x := 0 - x;
        end;
    end if;
    if x = 0 then
       begin
        x: = 1;
    end;
    end if;
end test;
4¡¢For Ñ­»·
For ... in ... LOOP
--Ö´ÐÐÓï¾ä
end LOOP;
(1)Ñ­»·±éÀúÓαê
create or replace procedure test() as
Cursor cursor is select name from student; name varchar(20);
begin
for name in cursor LOOP
begin
 dbms_output.putline(name); 
end;
end LOOP;
end test;
(2)Ñ­»·±éÀúÊý×é
 create or replace procedure test(varArray in myPackage.TestArray) as
--(ÊäÈë²ÎÊývarArray ÊÇ×Ô¶¨ÒåµÄÊý×éÀàÐÍ£¬¶¨Ò巽ʽ¼û±êÌâ6)
i number;
begin
i := 1;  --´æ´¢¹ý³ÌÊý×éÊÇÆðʼλÖÃÊÇ´Ó1¿ªÊ¼µÄ£¬Óëjava¡¢C¡¢C++µÈÓïÑÔ²»Í¬¡£ÒòΪÔÚOracleÖб¾ÊÇûÓÐÊý×éµÄ¸ÅÄîµÄ£¬Êý×éÆäʵ¾ÍÊÇÒ»ÕÅ
--±í(Table),ÿ¸öÊý×éÔªËØ¾ÍÊDZíÖеÄÒ»¸ö¼Ç¼£¬ËùÒÔ±éÀúÊý×éʱ¾ÍÏ൱ÓÚ´Ó±íÖеĵÚÒ»Ìõ¼Ç¼¿ªÊ¼±éÀú
for i in 1..varArray.count LOOP     
dbms_output.putline('The No.'|| i || 'record in varArray is:'||varArray(i));  
 end LOOP;
end test;
5¡¢While Ñ­»·
whi


Ïà¹ØÎĵµ£º

oracleÓÅ»¯Æ÷

What circumstances we use ALL_ROWS and what circumstances we use FIRST_ROWS optimizer mode? This article is written in oracle9i.
First_rows attempts to optimize the query to get the very first row back to the client as fast as possible. This is good for an interactive client server environment wher ......

Oracle ERPϵ統½è´û¹ØÏµ±í

ϵͳ·Ö²½Öè²úÉúµÄ·Ö¼£º
1£©¿â´æÄ£¿é×÷½ÓÊÕʱ²úÉúµÄ·Ö¼Ϊ£º
½è£º²ÄÁϲɹº £¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
´û£ºÓ¦¼Æ¸ºÕ®
£¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
2£©¿â´æÄ£¿é×÷¼ìÑéÈë¿âʱ²úÉúµÄ·Ö¼Ϊ£º
ϵͳ²úÉúµÄ·Ö¼·Ö±ðΪ£º
1£©¿â´æÄ£¿é×÷½ÓÊÕʱ²úÉúµÄ·Ö¼Ϊ£º
½è£º²ÄÁϲɹº
£¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
´û£ºÓ¦¼Æ¸ºÕ®
£¨²É¹ºµ¥¼ÛX¶©µ¥Ê ......

Oracle EBS ÈçºÎÔ½áÖ®Ó¦¸¶(AP)¶ÔÕËÏê½â

Ó¦¸¶Ä£¿éµÄ¶àÊýÒµÎñ»ùÓڲɹººÍ¿â´æµÄ²Ù×÷£¬Òò´ËÓ¦¸¶Ä£¿éµÄÔ½áÓ¦¸ÃÔڲɹºÄ£¿éºÍ¿â´æÄ£¿éÔ½áºó²ÅÄÜ¹Ø±Õ»á¼ÆÆÚ¡£
Ô½ᲽÖè
ÔÚÿ¸ö»á¼ÆÆÚÄ©£¬Ó¦¸¶Ä£¿éµÄÔ½áÓ¦×ñÑ­ÒÔÏÂÁ÷³Ì£º
1.¼ì²éÒµÎñÊÇ·ñÈ«²¿Â¼Èë;
2.¼ì²éÊÇ·ñÓÐδÑéÖ¤¡¢Ôݹҷ¢Æ±;
3.¸üе½ÆÚµÄÔ¶ÆÚ¸¶¿î״̬;
4.¼ì²éÓ¦¸¶ÒµÎñÊÇ·ñÉú³É·Ö¼;
5.Ó¦¸¶ÒµÎñ´«Ë͵½×ÜÕÊ;
6 ......

oracleÖÐÖØÃüÃûÁÐÃûºÍ±íÃû

ÎÒÃÇÔÚ´´½¨±í½á¹¹µÄ¹ý³ÌÖУ¬¿ÉÄÜ»áÓÉÓÚʧÎó£¬Ôì³É±íÖÐÁÐÃû´íÎó£¬ÈçºÎ¸ü¸ÄÄØ£¬Äã¿ÉÄÜ»á»Ø´ð£¬Ê¹ÓÃOEM»òÕßPL/SQL£¬³ýÁËÕâÁ½ÖÖ·½·¨£¬ÎÒÃÇ¿ÉÒÔʹÓÃÃüÁ
   ALTER TABLE ±íÃû rename   column  ÁÐÃû to ÐÂÁÐÃû     ×¢ÒâcolumnÊǹؼü×Ö   /*ÖØÃüÃûÁÐÃû*/
  ALTE ......

Oracle LongÐÍ

Oracle LongÐÍ
 
1¡¢LONG Êý¾ÝÀàÐÍÖд洢µÄÊǿɱ䳤×Ö·û´®£¬×î´ó³¤¶ÈÏÞÖÆÊÇ2GB¡£
2¡¢¶ÔÓÚ³¬³öÒ»¶¨³¤¶ÈµÄÎı¾£¬»ù±¾Ö»ÄÜÓÃLONGÀàÐÍÀ´´æ´¢£¬Êý¾Ý×ÖµäÖкܶà¶ÔÏóµÄ¶¨Òå¾ÍÊÇÓÃLONGÀ´´æ´¢µÄ¡£
3¡¢LONGÀàÐÍÖ÷ÒªÓÃÓÚ²»ÐèÒª×÷×Ö·û´®ËÑË÷µÄ³¤´®Êý¾Ý£¬Èç¹ûÒª½øÐÐ×Ö·ûËÑË÷¾ÍÒªÓÃvarchar2ÀàÐÍ¡£
4¡¢ºÜ¶à¹¤¾ß£¬°üÀ¨SQL*Plus£¬´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ