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

Create directoryÈÃÎÒÃÇ¿ÉÒÔÔÚOracleÊý¾Ý¿âÖÐÁé»îµÄ¶ÔÎļþ½øÐжÁд²Ù×÷£¬¼«´óµÄÌá¸ßÁËOracleµÄÒ×ÓÃÐԺͿÉÀ©Õ¹ÐÔ¡£
ÆäÓ﷨Ϊ:
CREATE [OR REPLACE] DIRECTORY directory
AS 'pathname
';
±¾°¸Àý¾ßÌå´´½¨ÈçÏÂ:
create or replace directory exp_dir as '/tmp';
Ŀ¼´´½¨ÒԺ󣬾ͿÉÒ԰ѶÁдȨÏÞÊÚÓèÌØ¶¨Óà ......

´Ó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Ö´Ðмƻ®

³£Ó÷½·¨ÓÐÒÔϼ¸ÖÖ£º
Ò»¡¢Í¨¹ýPL/SQL Dev¹¤¾ß
    1¡¢Ö±½ÓFile->New->Explain Plan Window£¬ÔÚ´°¿ÚÖÐÖ´ÐÐsql¿ÉÒԲ鿴¼Æ»®½á¹û¡£ÆäÖУ¬Cost±íʾcpuµÄÏûºÄ£¬µ¥Î»Îªn%£¬Cardinality±íʾִÐеÄÐÐÊý£¬µÈ¼ÛRows¡£
    2¡¢ÏÈÖ´ÐÐ EXPLAIN PLAN FOR   select * from tableA ......

OracleÈÏÖ¤½éÉÜ

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

Access¡¢SQLServer¡¢Oracle³£¼ûSQLÓï¾äÓ¦ÓÃÇø±ð


Access¡¢SQLServer¡¢Oracle³£¼ûSQLÓï¾äÓ¦ÓÃÇø±ð
¹Ø¾¢ËÉ PMP
Èç¹ûÒª¼æÈÝAccess¡¢SQL Server¡¢OracleÈý¸öÊý¾Ý¿â°æ±¾£»ÎÒÃÇÔÚ±àдSQLÓï¾äµÄ¹ý³ÌÖУ¬¾¡Á¿Ê¹ÓÃһЩͨÓõÄÓï¾ä£¬µ«»¹ÊÇÓÐЩ·½ÃæÓÐÐ©Çø±ð±ÜÃâ²»ÁË£¬ÏÖ¼òµ¥×ܽáһϡ£
ÒÔÏÂA´ú±íAccess,S´ú±íSQL Server,O´ú±íOracle
1¡¢È¡µ±Ç°ÏµÍ³Ê±¼ä
A:Select Now()
S:Selec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ