Oracle´æ´¢¹ý³Ì½Ì³Ì
Ò»¸ö¼òµ¥µÄoracle·ÖÒ³´æ´¢¹ý³ÌµÄʵÏֺ͵÷Óá£ÔÚ¿´ÁËÖÚ¶àµÄ·ÖÒ³´æ´¢¹ý³ÌÒÔºó·¢ÏÖ¶¼ÊÇÕë¶ÔsqlserverµÄ£¬¶øûÓÐoracleµÄ£¬Òò´ËÏëдһ¸ö¹ØÓÚoracleµÄ´æ´¢¹ý³Ì£¬ÒòΪÎÒÓõ½µÄÊý¾Ý¿âÊÇoracle¡£
Oracle·ÖÒ³´æ´¢¹ý³ÌµÄ˼·ÓÚsqlserverµÄ˼·ÊÇÒ»ÑùµÄ£¬µ«ÊÇÎÒÕâÀï×öÁ˵ã¸Ä¶¯£¬ÔÚÒòΪOracleµÄÓï·¨ºÍ¹æÔòµÄ²»Í¬ËùÒÔ£¬Oracle·ÖÒ³´æ´¢¹ý³Ì¿´ÉÏÈ¥Óе㲻һÑù¡£¼ûЦ£¬¼ûЦ£¡
ÔÚOracleµÄ´æ´¢¹ý³ÌÖзµ»Ø¼Ç¼¼¯£¬ÐèÒªÓõ½Óαê±äÁ¿£¬Oracle²»ÄÜÏñsqlserverÄÇÑù¿ÉÒÔÖ±½Ó·µ»ØÒ»¸ö¼Ç¼¼¯¡£
ÓÉÓÚÉèÏëÔÚ.netÖаѸ´ÔÓµÄsqlÓï¾äÉú³É£¬ËùÒÔÔÚ´æ´¢¹ý³ÌÖÐûÓÐÈ¥¿¼ÂÇÉú³ÉsqlÓï¾äµÄÎÊÌâ¡£
ÒÔÏÂÊÇÔÚOracleÖÐʵÏֵķÖÒ³´æ´¢¹ý³Ì¡£
create or replace package DotNet is
-- Author : good_hy
-- Created : 2004-12-13 13:30:30
-- Purpose :
TYPE type_cur IS REF CURSOR; --¶¨ÒåÓαê±äÁ¿ÓÃÓÚ·µ»Ø¼Ç¼¼¯
PROCEDURE DotNetPagination(
Pindex in number, --·ÖÒ³Ë÷Òý
Psql in varchar2, --²úÉúdatasetµÄsqlÓï¾ä
Psize in number, --Ò³Ãæ´óС
Pcount out number, --·µ»Ø·ÖÒ³×ÜÊý
v_cur out type_cur --·µ»Øµ±Ç°Ò³Êý¾Ý¼Ç¼
);
procedure DotNetPageRecordsCount(
Psqlcount in varchar2, --²úÉúdatasetµÄsqlÓï¾ä
Prcount out number --·µ»Ø¼Ç¼×ÜÊý
);
end DotNot;
create or replace package body DotNet is
--***************************************************************************************
PROCEDURE DotNetPagination(
Pindex in number,
Psql in varchar2,
Psize in number,
Pcount out number,
v_cur out type_cur
)
AS
v_sql VARCHAR2(1000);
v_count number;
v_Plow number;
v_Phei number;
Begin
------------------------------------------------------------È¡·ÖÒ³×ÜÊý
v_sql := 'select count(*) from (' || Psql || ')';
execute immediate v_sql into v_count;
Pcount := ceil(v_count/Psize);
------------------------------------------------------------ÏÔʾÈÎÒâÒ³ÄÚÈÝ
v_Phei := Pindex * Psize + Psize;
v_Plow := v_Phei - Psize + 1;
--Psql := 'select rownum rn,t.* from c
Ïà¹ØÎĵµ£º
FORALLÓï¾äµÄÒ»¸ö¹Ø¼üÐԸĽø£¬Ëü¿É´ó´ó¼ò»¯´úÂ룬²¢ÇÒ¶ÔÓÚÄÇЩҪÔÚPL/SQL³ÌÐòÖиüкܶàÐÐÊý¾ÝµÄ³ÌÐòÀ´Ëµ£¬Ëü¿ÉÏÔÖøÌá¸ßÆäÐÔÄÜ¡£
1:
ÓÃFORALLÀ´ÔöÇ¿DMLµÄ´¦ÀíÄÜÁ¦
OracleΪOracle8iÖеÄPL/SQLÒýÈëÁËÁ½¸öеÄÊý¾Ý²Ù×ÝÓïÑÔ£¨DML£©Óï¾ä£ºBULK COLLECTºÍFORALL¡£ÕâÁ½¸öÓï¾äÔÚPL/SQLÄÚ²¿½øÐÐÒ»ÖÖÊý×é´¦Àí
£»BULK COLLE ......
RMAN> startup nomount;
RMAN> sql 'alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
--ÒòΪrmanĬÈÏÒÔ»·¾³±äÁ¿À´¶Áȡʱ¼ä¸ñʽ£¬ÓësqlplusµÄ¹Ì¶¨¸ñʽ²»Í¬£¬ËùÒÔ£¬´Ë´¦ÒªÉ趨ʱ¼ä¸ñʽ±äÁ¿¡£
RMAN> restore controlfile from autobackup until time '2009-03-10 18:15:00';
×¢Ò⣬ÈÔÈ»ÐèÒªÊʵ±µ ......
OracleÊý¾Ý¿âº¯Êý£¨µ¥Ðк¯Êý£©
OracleÖеĺ¯ÊýºÍCÖеĺ¯Êý²î²»¶à£¬Ò²ÊÇÓк¯ÊýÃû£¬²ÎÊý±í£¬ºÍ·µ»ØÖµÀàÐÍ×é³ÉµÄ£¬µ¥Ðк¯Êý£¬ÊÇÕë¶ÔÿÌõ¼Ç¼¶¼ÓÐÒ»¸ö½á¹û¡£µ¥Ðк¯Êý¿ÉÒÔ³öÏÖÔÚselect ºóÃ棬Ҳ¿ÉÒÔ³öÏÖÔÚwhere×Ó¾äÖС£
ÐèÒª´¦ÀíÏÖʵµÄ½á¹ûʱ£¬¾Í°Ñº¯ÊýдÔÚselectºóÃ棬ÓÃÓÚÌõ¼þ¹ýÂËʱ£¬¾Í°Ñº¯Êý ......
±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌرðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ ......
Oracle ·ÖÇø±í
OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔ ......