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

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


Ïà¹ØÎĵµ£º

OracleÍⲿ±íСÀý

1)½¨Á¢²Ù×÷ϵͳĿ¼e:\test£¬×¼±¸Êý¾ÝÎļþdept.txt²¢ÖÃÓÚe:\testÖ®ÏÂ
"10","ACCOUNTING","NEW
YORK"
"20","RESEARCH","DALLAS"
"30","SALES","CHICAGO"
"40","OPERATIONS","BOSTON"
2)´´ ......

ORACLE°²×°Ö®ºóµÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·

2009-01-02 10:02
µÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·
     OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðΪµ¼³ö/µ¼È루EXPORT/IMPORT£©¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼­±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
     Òª½øÐб¸·ÝºÍ»Ö¸´²Ý£¬±ØÐëÔÚÁ¬½Óµ½Oracle Manager Serverºó²ÅÄܽøÐС£Èç¹ûδ´ ......

Oracle֪ʶ£¨¶þ£©

 
OracleÊý¾Ý¿âº¯Êý£¨µ¥Ðк¯Êý£©
 
OracleÖеĺ¯ÊýºÍCÖеĺ¯Êý²î²»¶à£¬Ò²ÊÇÓк¯ÊýÃû£¬²ÎÊý±í£¬ºÍ·µ»ØÖµÀàÐÍ×é³ÉµÄ£¬µ¥Ðк¯Êý£¬ÊÇÕë¶ÔÿÌõ¼Ç¼¶¼ÓÐÒ»¸ö½á¹û¡£µ¥Ðк¯Êý¿ÉÒÔ³öÏÖÔÚselect ºóÃ棬Ҳ¿ÉÒÔ³öÏÖÔÚwhere×Ó¾äÖС£
 
ÐèÒª´¦ÀíÏÖʵµÄ½á¹ûʱ£¬¾Í°Ñº¯ÊýдÔÚselectºóÃ棬ÓÃÓÚÌõ¼þ¹ýÂËʱ£¬¾Í°Ñº¯Êý ......

Oracle ·ÖÇø±í

Oracle ·ÖÇø±í
OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ