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

OracleÊý×éÈëÃÅ

OracleÊý×éÒ»°ã¿ÉÒÔ·ÖΪ¹Ì¶¨Êý×éºÍ¿É±äÊý×é
¹Ì¶¨Êý×é
Sql´úÂë
   declare 
   type v_ar is varray(10) of varchar2(30); 
   my_ar v_ar:=v_ar('g','m','d','¹¨','˧'); 
   begin 
          for i in 1..my_ar.count 
          loop 
              dbms_output.put_line(my_ar(i)); 
          end loop; 
    end; 
declare
type v_ar is varray(10) of varchar2(30);
my_ar v_ar:=v_ar('g','m','d','¹¨','˧');
begin
      for i in 1..my_ar.count
      loop
          dbms_output.put_line(my_ar(i));
      end loop;
end;
¿É±äÊý×é
һάÊý×é
Sql´úÂë
    declare 
    type v_table is table of varchar2(30) index by binary_integer; 
    --ÀàÐÍ¿ÉÒÔÊÇÇ°ÃæµÄÀàÐͶ¨Ò壬index by binary_integer×Ó¾ä´ú±íÒÔ·ûºÅÕûÊýΪË÷Òý£¬ 
    --ÕâÑù·ÃÎʱíÀàÐͱäÁ¿ÖеÄÊý¾Ý·½·¨¾ÍÊÇ“±í±äÁ¿Ãû(Ë÷Òý·ûºÅÕûÊý)”¡£ 
    my_table v_table; 
    begin 
          for i in 1..20 
          loop 
              my_table(i):=i; 
             dbms_output.put_line(my_table(i)); 
         end loop; 
   end; 
declare
type v_table is table of varchar2(30) index by binary_integer;
--ÀàÐÍ¿ÉÒÔÊÇÇ°ÃæµÄÀàÐͶ¨Ò壬index by binary_integer×Ó¾ä´ú±íÒÔ·ûºÅÕûÊýΪË÷Òý£¬
--


Ïà¹ØÎĵµ£º

ÈçºÎ¸ßЧɾ³ýOracleÊý¾Ý¿âÖеÄÖØ¸´Êý¾Ý

Oracle Êý¾Ý¼¯³É½â¾ö·½°¸
¡¡¡¡OracleÊý¾Ý¼¯³É½â¾ö·½°¸ÓÃÓÚÔÚSOA¡¢BIºÍÊý¾Ý²Ö¿â»·¾³Öй¹½¨¡¢²¿ÊðºÍ¹ÜÀíÒÔʵʱÊý¾ÝΪÖÐÐĵļܹ¹£¬°üº¬ÁËÊý¾Ý¼¯³ÉµÄËùÓÐÒªËØ——ʵʱÊý¾ÝÒÆ¶¯¡¢×ª»»¡¢Í¬²½¡¢Êý¾ÝÖÊÁ¿¡¢Êý¾Ý¹ÜÀíºÍÊý¾Ý·þÎñ——ÄÜÈ·±£¸÷¸ö¸´ÔÓϵͳµÄÐÅÏ¢¼°Ê±¡¢×¼È·¡¢Ò»Ö¡£
¡¡¡¡Í¨¹ýʹÓÃOracleÊý¾Ý¼¯³É£¬Æó ......

´Óoracle±íÖÐËæ»úÈ¡¼Ç¼£¬²úÉúËæ»úÊýºÍËæ»ú×Ö·û´®


1¡¢´Ó±íÖÐËæ»úÈ¡¼Ç¼
    select * from (select * from staff order by dbms_random.random)
    where rownum < 4
    ±íʾ´ÓSTAFF±íÖÐËæ»úÈ¡3Ìõ¼Ç¼
2¡¢²úÉúËæ»úÊý
        SELECT DBMS_RANDOM.RANDOM from DUAL;
     ......

OracleÈÏÖ¤½éÉÜ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿â¹ÜÀíÈËÔ±ÉϸڵÄÒÀ¾Ý¡£
ĿǰÒѳÉΪ¸÷IT¹«Ë¾¼°Ïà¹ØÆóÒµÕùÏྺƸµÄÊý¾Ý¿â¹ÜÀíά»¤È˲ţ¬ÊÇÊý¾Ý¿âά»¤¹ÜÀíÈËÔ ......

֨װ²Ù×÷ϵͳºóµÄoracleʵÀý»Ö¸´


֨װ²Ù×÷ϵͳºó,Èç¹ûÊý¾ÝÎļþ,¿ØÖÆÎļþ,ÈÕÖ¾Îļþ¶¼ÍêºÃµÄ»°(ÔÚitpub¿´¹ýºÜ¶àÈËÌá¹ýÕâ¸ö»°Ìâ,¶àÊýÈ˶¼Êǽ«Õâ3¸öÎļþ·ÅÔÚͬһĿ¼oradata),Ö»ÐèÖØÐ°²×°oracle(¸ú֨װ²Ù×÷ϵͳǰͬ°æ±¾)µ½Ô­Ä¿Â¼ºó,ÖØ½¨ÊµÀý·þÎñºÍÃÜÂëÎļþ,ÅäÖÃÒ»ÏÂlistenerºÍtns¼´¿ÉÕý³£Æô¶¯Êý¾Ý¿â.
¹ý³ÌÈçÏÂ(¼ÙÉèԭʵÀýÃûΪorcl,°æ±¾Îª9i):
1.½«Ô­À´µÄor ......

ÈçºÎÔÚOracleÖÐʹÓÃJava´æ´¢¹ý³Ì (Ïê½â)

Æäʵ£¬ÕâÆª¶ÌÎÄ£¬ÎÒÔç¾ÍÓ¦¸ÃдÁË¡£ÒòΪ£¬java´æ´¢¹ý³Ì½ñºóÔÚ¸÷´óÊý¾Ý¿â³§ÉÌÖÐÔ½À´Ô½Á÷ÐУ¬¹¦ÄÜÒ²Ô½À´Ô½Ç¿´ó¡£ÕâÀïÒÔOracleΪÀý£¬½éÉÜÒ»ÏÂjava´æ´¢¹ý³ÌµÄ¾ßÌåÓ÷¨¡£
Ò»¡¢ÈçºÎ´´½¨java´æ´¢¹ý³Ì£¿
ͨ³£ÓÐÈýÖÖ·½·¨À´´´½¨java´æ´¢¹ý³Ì¡£
1. ʹÓÃoracleµÄsqlÓï¾äÀ´´´½¨£º
e.g. ʹÓÃcreate or replace and compile java source ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ