oracle 11gÎÞ·¨°²×° - Oracle / »ù´¡ºÍ¹ÜÀí
oracle 11g°²×°ÏȾöÌõ¼þ¼ì²éÈ«²¿Ê§°Ü£¬ÏêϸÐÅÏ¢ÈçÏ£º
//ÎïÀíÄÚ´æ
ÎïÀíÄÚ´æ - ´ËÏȾöÌõ¼þ½«²âÊÔϵͳÎïÀíÄÚ´æ×ÜÁ¿ÊÇ·ñÖÁÉÙΪ 922MB (944128.0KB)¡£
Ô¤ÆÚÖµ
: N/A
ʵ¼ÊÖµ
: N/A
´íÎóÁбí:
-
//¿ÉÓÃÎïÀíÄÚ´æ
PRVF-7531 : ÎÞ·¨ÔÚ½Úµã "LENOVO-F4F9938F" ÉÏÖ´ÐÐÎïÀíÄÚ´æ¼ì²é - Cause: ÎÞ·¨ÔÚָʾµÄ½ÚµãÉÏÖ´ÐÐÎïÀíÄÚ´æ¼ì²é¡£ - Action: È·±£¿ÉÒÔ·ÃÎÊÖ¸¶¨µÄ½Úµã²¢¿ÉÒԲ鿴ÄÚ´æÐÅÏ¢¡£
¿ÉÓÃÎïÀíÄÚ´æ - ´ËÏȾöÌõ¼þ½«²âÊÔϵͳ¿ÉÓÃÎïÀíÄÚ´æÊÇ·ñÖÁÉÙΪ 50MB (51200.0KB)¡£
Ô¤ÆÚÖµ
: N/A
ʵ¼ÊÖµ
: N/A
´íÎóÁбí:
-
PRVF-7563 : ÎÞ·¨ÔÚ½Úµã "LENOVO-F4F9938F" ÉÏÖ´ÐпÉÓÃÄÚ´æ¼ì²é - Cause: ÎÞ·¨ÔÚָʾµÄ½ÚµãÉÏÖ´ÐпÉÓÃÄÚ´æ¼ì²é¡£ - Action: È·±£¿ÉÒÔ·ÃÎÊÖ¸¶¨µÄ½Úµã²¢¿ÉÒԲ鿴ÄÚ´æÐÅÏ¢¡£
//½»»»¿Õ¼ä´óС
½»»»¿Õ¼ä´óС - ´ËÏȾöÌõ¼þ½«²âÊÔϵͳÊÇ·ñ¾ßÓÐ×ã¹»µÄ×ܽ»»»¿Õ¼ä¡£
Ô¤ÆÚÖµ
: N/A
ʵ¼ÊÖµ
: N/A
´íÎóÁбí:
-
PRVF-7574 : ÎÞ·¨ÔÚ½Úµã "LENOVO-F4F9938F" ÉÏÖ´Ðн»»»¿Õ¼ä´óС¼ì²é - Cause: ÎÞ·¨ÔÚָʾµÄ½ÚµãÉÏÖ´Ðн»»»¿Õ¼ä¼ì²é¡£ - Action: È·±£¿ÉÒÔ·ÃÎÊÖ¸¶¨µÄ½Úµã²¢¿ÉÒԲ鿴½»»»¿Õ¼äÐÅÏ¢¡£
-
PRVF-7531 : ÎÞ·¨ÔÚ½Úµã "LENOVO-F4F9938F" ÉÏÖ´ÐÐÎïÀíÄÚ´æ¼ì²é - Cause: ÎÞ·¨ÔÚָʾµÄ½ÚµãÉÏÖ´ÐÐÎïÀíÄÚ´æ¼ì²é¡£ - Action: È·±£¿
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......