(ת)oracleºÍdb2Çø±ð
ÏîÄ¿ÖÐÒ»Ö±¶¼ÊÇÓÃdb2£¬ËùÒÔ¶Ôdb2Ò²ËãÓиöÒ»Öª°ë½â£¬¶ø¶ÔoracleÔòÊÇÖªÖ®ÉõÉÙ£¬Ò»Ö±¿àÓÚûÓлú»áÀ´Á·ÊÖ¡£×î½üÏîÄ¿×éÔÚ×ödb2µ½oracleµÄÇ¨ÒÆ£¬ÖÕÓÚ´þ×Å»ú»áÁË¡£½ñÌì¼òµ¥ËµÐ©ÔÚʵ¼ÊÏîÄ¿Óöµ½µÃһЩÎÊÌ⣬ÒÔºóÔÙÂýÂý²¹³ä¡£Í¬Ê±Ò²Ï£ÍûÈÊÈË־ʿ¶à¶àÖ¸µã¡£
ÓÉÓÚÕâÁ½Ìì¶¼ÊÇ×ö´æ´¢¹ý³ÌµÄÇ¨ÒÆ£¬ËùÒÔÕâÀïÖ÷Òª½²µ½µÄÊÇdb2ºÍoracleÁ½Õß´æ´¢¹ý³ÌÒÔ¼°Ò»Ð©ÏµÍ³º¯ÊýµÄÇø±ð¡£
1¡¢´´½¨PROCEDUREµÄ²ÎÊýµÄÇø±ð
1£©²ÎÊýÀàÐͺͲÎÊýÃû³ÆµÄλÖò»Í¬
db2£º CREATE PROCEDURE PRO1 (IN OrgID int)
oracle£ºCREATE PROCEDURE PRO1 (OrgID IN int)
2£©Í¬Ê±×÷ΪÊäÈëÊä³ö²ÎÊýµÄд·¨²»Í¬
db2£º CREATE PROCEDURE PRO1 (INOUT OrgID int) INOUTÁ¬×Åд
oracle£ºCREATE PROCEDURE PRO1 (OrgID IN OUT int) IN OUTÖмä¿Õ¸ñ¸ô¿ª£¬¶øÇÒ±ØÐëINÔÚOUT֮ǰ
3£©Ã»ÓÐÊäÈë»òÊä³ö²ÎÊýʱ
db2£º CREATE PROCEDURE PRO1 ()
oracle£ºCREATE PROCEDURE PRO1 ²»ÄÜÓпյÄÀ¨ºÅ
2¡¢±äÁ¿¶¨ÒåºÍBEGIN ENDÌåµÄλÖò»Í¬
db2ÖбäÁ¿¶¨ÒåÔÚBEGIN ENDÌåÄÚ£¬²¢ÇÒÿ¸ö±äÁ¿¶¼ÒªÓÃDECLAREÉùÃ÷£»´æ´¢¹ý³Ì½áÊøÊ±£¬ENDºó¸úP1£¬²¢ÇÒ²»ÐèÒª·ÖºÅ
oracleÖбäÁ¿¶¨Ò屨ÐëÔÚBEGIN ENDÌåÍ⣬±äÁ¿¶¼²»ÐèÒªÓÃDECLAREÉùÃ÷(ÓÐÖÖ˵·¨ÊÇ£¬µÚÒ»¸ö±äÁ¿ÐèÒªDECLARE£¬ÆäËû±äÁ¿²»ÐèÒª)£»´æ´¢¹ý³Ì½áÊøÊ
Ïà¹ØÎĵµ£º
±¾ÎÄ»·¾³ÅäÖãºOracle10gR2£¬Windows XP
OracleµÄÓû§ÐÅÏ¢Ò»°ãÀ´ËµÊDZ£´æÔÚÊý¾Ý×ÖµäÀïµÄ£¬ËùÒÔ³£¹æÓû§ÔÚOracleÊý¾Ý¿âûÓÐÆô¶¯µÄʱºòÊÇÎÞ·¨µÇ½µÄ¡£µ«ÓÐÁ½ÀàÓû§ÀýÍ⣬Õâ¾ÍÊǾßÓÐsysdba»òÕßsysoperȨÏÞµÄÓû§¡£Oracle sysdba»òÕßsysoperÓû§µÄµÇ½ÓÐÁ½ÖÖ·½Ê½£ºÒ»ÊÇͨ¹ýOSÈÏÖ¤£¬¶þÊÇͨ¹ýÃÜÂëÎļþÑéÖ¤¡£
¾¿¾¹Ê¹ÓÃÄÄÒ»ÖÖÑéÖ¤ ......
Tomcat4.0ÓëOracleÔõô½¨Á¢Á¬½Ó³Ø£¿½¨ºÃºóÔõô²âÊÔ£¿
×÷Õߣºdorawo 2003Äê11ÔÂ07ÈÕ 10:01 ½øÈëÂÛ̳
Ïà¹ØÌÖÂÛ:oracle Á¬½Ó³Øweblogic½¨Á¢Á¬½Ó³ØÁ¬½Ó³Øtomcat Á¬½Ó³Øjava Á¬½Ó³Øhibernate Á¬½Ó³Ømys ......
--ORACLE ÐÐתÁÐ ²âÊÔͨ¹ý£¨9i£©
/***************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶®
***********************************************************************************************************/
--1¡¢ÐÐתÁÐ
......
oracleÐÐתÁÐͨÓùý³Ì(ת)
»·¾³oracle 10g
¹¤×÷¹ØÏµ,³£×öЩÐÐתÁб¨±í,±¨±íͨ³£²»ÊÇÔÚ´óÊý¾Ý¼¯ºÏÉÏ´¦Àí.
ËùÒÔдÁ˸ö¹ý³Ì.
±¾¹ý³Ì±È½ÏÊʺÏÔÚÓÚÐèÒª¶¯Ì¬Êä³ö±¨±íµÄµØ·½,ÀýÈçwebÖÐ.
²»ÊǺÜÍêÃÀ,µ«ÒѾ¿ÉÒÔ½â¾ö¾ø´ó²¿·ÖµÄÎÊÌâ.
create or replace function func_RowToCol(
viewName Varchar2,
grpCols Varchar2,
colC ......
ÔÚÏÖ´úµÄ¶àÓû§¶àÈÎÎñϵͳÖУ¬±ØÈ»»á³öÏÖ¶à¸öÓû§Í¬Ê±·ÃÎʹ²ÏíµÄij¸ö¶ÔÏó£¬Õâ¸ö¶ÔÏó¿ÉÄÜÊÇ±í£¬ÐУ¬»òÕßÄÚ´æ½á¹¹£¬ÎªÁ˽â¾ö¶à¸öÓû§²¢·¢ÐÔ·ÃÎÊ´øÀ´µÄÊý¾ÝµÄ°²È«ÐÔ£¬ÍêÕûÐÔ¼°Ò»ÖÂÐÔÎÊÌ⣬±ØÐëÒªÓÐÒ»ÖÖ»úÖÆ£¬À´Ê¹¶ÔÕâЩ¹²Ïí×ÊÔ´µÄ²¢·¢ÐÔ·ÃÎÊ´®Ðл¯£¬oracleÖеÄËø¾Í¿ÉÒÔÌṩÕâÑùµÄ¹¦ÄÜ£¬µ±ÊÂÎñÔÚ¶Ôij¸ö¶ÔÏó½øÐвÙ×÷ǰ£¬ÏÈÏòϵͳ ......