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

Oracle´æ´¢¹ý³ÌµÄÖ´ÐÐ

declare
msg varchar(1000);    --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg);   --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg);   --Êä³ö±äÁ¿
end;


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Oracleѧϰ±Ê¼Çժ¼2

    µ¥Ðк¯Êý   ·µ»ØÖµÖ»ÓÐÒ»¸ö
      
   ·Ö×麯Êý   ·µ»ØÖµÊǶàÌõ¼Ç¼
      group by
      sum
      avg         ......

Oracleѧϰ±Ê¼Çժ¼10

 <1>Âß¼­±¸·Ý
  ²»ÓÃÈ¥¿½±´Êý¾Ý¿âµÄÎïÀíÎļþ
  ±¸·ÝÂß¼­ÉϵĽṹ
  ÍⲿµÄ¹¤¾ß:µ¼³öºÍµ¼ÈëµÄ¹¤¾ß
  DOSϵÄÃüÁî cmdÏÂÖ´ÐÐ
    µ¼³öexp  exportËõдÐÎʽ
²é¿´°ïÖú exp help=y
    ʹÓòÎÊýÎļþµ¼³ö
     exp parfile=c:\ab ......

Oracle Job Óï·¨ºÍʱ¼ä¼ä¸ôµÄÉ趨

³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
job_queue_process ±íʾoracleÄܹ»²¢·¢µÄjobµÄÊýÁ¿£¬¿ÉÒÔͨ¹ýÓï¾ä¡¡¡¡
show parameter job_queue_process;
À´²é¿´oracleÖÐjob_queue_processµÄÖµ¡ ......

oracle °ü

 package¾ÍÊÇÓÃÀ´·â×°¹ý³Ì£¬º¯ÊýÓõġ£
Ò»¸öpackage¿ÉÒÔ´æ·Å¶à¸ö¹ý³Ì£¬º¯Êý¡£
µ÷ÓÃÊÇ£º
°üÃû.¹ý³ÌÃû1
°üÃû.¹ý³ÌÃû2
http://hank4ever.javaeye.com/blog/472336
°ü (package)
¡¡¡¡(1)°üµÄÒâÒå
¡¡¡¡pl/sqlΪÁËÂú×ã³ÌÐòÄ£¿é»¯µÄÐèÒª,³ýÁË¿é(block)ºÍ×Ó³ÌÐò½á¹¹Íâ,»¹ÒýÈëÁË°üµÄ¹¹Ôì¡£
¡¡¡¡°üÊÇÒ»ÖÖÊý¾Ý¿â¶ÔÏó,½«Â ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ