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

Oracle´æ´¢¹ý³Ì

ÏÖÔÚµÄÏîÄ¿±È½Ï½ô£¬¼ÓÉÏ×Ô¼ºÒ²±È½ÏÀÁ£¬ÊµÔÚÊǓûʱ¼ä”д°¡£¬ºÇºÇ£¬×òÌì¿´µ½Ò»ÆªÍ¦ºÃµÄOracle´æ´¢¹ý³ÌµÄÀý×Ó£¬ÕýºÃ×î½üÒªÓã¬×ª¹ýÀ´´ó¼ÒÒ»Æð·ÖÏíһϣ¬Ð»Ð»£¨³¿¹âӳϼ£©£¬Ô­×÷µØÖ·£ºhttp://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx¡£
--------------------×Ô¶¨Ò庯Êý¿ªÊ¼--------------------
CREATE OR REPLACE FUNCTION fn_WFTemplateIDGet
(
    TemplateCategoryID NUMBER,
    OrganID NUMBER,
    TemplateMode NUMBER
)
RETURN NUMBER
IS
    TemplateID NUMBER;
    ItemCount NUMBER;
BEGIN
    --È¡Ä£°åÖÐÖ¸¶¨»ú¹¹,Ö¸¶¨·ÖÀàµÄ¹¤×÷Á÷Ä£°å¼Ç¼
    SELECT COUNT(*) INTO ItemCount
    from t_WFTemplate
    WHERE f_OrganID = OrganID AND f_TemplateCategoryID = TemplateCategoryID;
    IF ItemCount = 1 THEN
        SELECT f_TemplateID INTO TemplateID
        from t_WFTemplate
        WHERE f_OrganID = OrganID AND f_TemplateCategoryID = TemplateCategoryID;
    ELSE
        TemplateID := 0;
    END IF;
    RETURN(TemplateID);
END fn_WFTemplateIDGet;
--------------------×Ô¶¨Ò庯Êý½áÊø--------------------
--------------------°üÍ·¿ªÊ¼--------------------
CREATE OR REPLACE PACKAGE pkg_TEMP is
    TYPE curRecordset IS REF CURSOR;
   
    --¹¦ÄÜ£ºÓÉÈËÔ±»ñÈ¡Êý¾Ý
    PROCEDURE up_ModuleShowByEmployeeID
    (
        EmployeeID NUMBER,
        objRs OUT curRecordset
    );
END pkg_TEMP;
--------------------°üÍ·½áÊø--------------------
--------------------°üÌ忪ʼ--------------------
CREATE OR REPLACE PACKAGE BODY pkg_TEMP is
    --¹¦ÄÜ£ºÓÉÈËÔ±»ñÈ¡Êý¾Ý


Ïà¹ØÎĵµ£º

oracle²»Í¬schemaÖ®¼ä½¨Íâ¼ü

ÐèҪȨÏÞ:
  grant references on test_sys to user_1;
 or
  grant all on test_sys to user_1;
²âÊÔ£º
sysÓû§ÏÂ:
SQL> create user user_1 identified by user_1;
Óû§ÒÑ´´½¨¡£
SQL> grant dba to user_1;
ÊÚȨ³É¹¦¡£
SQL> create table test_sys(pk_col varchar2(5))
  2&nbs ......

OracleÏÞÖÆIP·ÃÎÊÉèÖÃ

Ò»¡¢$vi $ORACLE_HOME/network/admin/sqlnet.ora
Èç¹û¸Ãsqlnet.oraÎļþ²»´æÔÚ£¬¿ÉÒÔ²ÉÓÃÈçÏ·½Ê½Éú³É
1£©¿ÉÒÔ¿½±´$ORACLE_HOME/network/admin/samples/sqlnet.oraµ½$ORACLE_HOME/network/admin/Ŀ¼ÏÂʹÓÃ
2£©Ê¹ÓÃnetca¹¤¾ß½øÐÐÅäÖã¬NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
 
¶þ¡¢ÉèÖûòÐ޸IJÎÊý£¨Èç¹û²ÎÊ ......

ÂíÍõÒ¯Ô­´´ Oracle Installation for AIX 5L

ÒÔÏÂÒÔ½ØͼÐÎʽ¼òÊö¹ØÓÚÔÚIBMСÐÍ»úÉÏ°²×°µ¥»ú°æOracleÊý¾Ý¿âµÄ¹ý³Ì¡£ÒÔ¹©´ó¼Ò²Î¿¼£¬ÒÔ±ã¶ÔÓÚIBMСÐÍ»ú&AIX&Oracle½øÐгõ²½µÄÁ˽⡣ Machine£ºIBM POWER 520 OS&Version£ºAIX_5300-07 Oracle Version:10.2.0.1 ÒÔÏÂÊÇÏêϸ½Øͼ£º 1_OS_Check&Filesets_Check 2_ÀûÓÃsmitty installpÃüÁî½øÈëÈí¼þ£¨°ü£ ......

11gµÄOracle Grid Infrastructure

2010Äê05ÔÂ2ºÅ  | 
23:59·ÖÀࣺLinux&Unix
, ¹ÜÀíά»¤
  |  ±à¼­
  |  ±êÇ©£º11g
¡¢grid

±¾Îijö×Ô “inthirties£¨ÄÐ
ÈËÈýÊ®£©
”²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦¡£
11gÀï³öÏÖÁËÒ»¸öнÇÉ«¡£
Oracle Grid Infrastructure
http://downlo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ