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
--¹¦ÄÜ£ºÓÉÈËÔ±»
Ïà¹ØÎĵµ£º
ʹÊÔÒò:
1.ÓÉÓÚÎó²Ù×÷ÓÃhp unix ÃüÁî rm -f datafilename ɾ³ý±í¿Õ¼äµÄÊý¾ÝÎļþ
2.alter tablespace tablespacenaem drop datafile datafile ;
3.drop tablespace tablespacename including content and datafiles;
ÉÏÊöÁ½¸ö²½ÖèÎÒÓÃÁ˽üÈý¸öСʱ¶¼Ã»ÓÐÖ´ÐÐÍ꣬×îºóµ¼ÖÂÊý¾Ý¿âå´»ú¡£ÏÂÃæ°ÑÎÒµ±Ê±Æô¶¯Êý¾ÝµÄºóÌ¨Ò ......
author:skatetime:2010-05-04
ÔÚÎÒÃǵÄϵͳÀ´ó¼ÒÔÚдpl/sqlʱ£¬´¦Àí¶àÌõ¼Ç¼ʱ£¬¼¸ºõ¶¼ÊÇͨ¹ýÓαêÀ´Íê³ÉµÄ£¬ÕâÑùÊǷdz£Ó°ÏìÐÔÄܵġ£ÎÒÃÇ¿ÉÒÔÓÃÅúÁ¿°ó¶¨¿ÉÒÔ´ó´óµÄ¸ÄÉÆ¡£
ÅúÁ¿°ó¶¨ÊÇoracle9iÔö¼ÓµÄÌØÐÔ£¬ÊÇÖ¸Ö´Ðе¥´Îsql²Ù×÷ÄÜ´«µÝËùÓм¯ºÏÔªËصÄÊý¾Ý¡£Í¨¹ý°ó¶¨°ó¶¨±äÁ¿¿ÉÒÔ¼«´óµÄÌá¸ßÊý¾Ý´¦ÀíËٶȣ¬Ìá¸ßÓ¦ÓÃ³Ì ......
Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECO ......
Temporary TablesÁÙʱ±í
1¼ò½é
ORACLEÊý¾Ý¿â³ýÁË¿ÉÒÔ±£´æÓÀ¾Ã±íÍ⣬»¹¿ÉÒÔ½¨Á¢ÁÙʱ±ítemporary tables¡£ÕâЩÁÙʱ±íÓÃÀ´±£´æÒ»¸ö»á»°SESSIONµÄÊý¾Ý£¬
»òÕß±£´æÔÚÒ»¸öÊÂÎñÖÐÐèÒªµÄÊý¾Ý¡£µ±»á»°Í˳ö»òÕßÓû§Ìá½»commitºÍ»Ø¹örollbackÊÂÎñµÄʱºò£¬ÁÙʱ±íµÄÊý¾Ý×Ô¶¯Çå¿Õ£¬
µ«ÊÇÁÙʱ± ......