(ת)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£¬ÆäËû±äÁ¿²»ÐèÒª)£»´æ´¢¹ý³Ì½áÊøÊ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÔÚÃüÁî¸ñʽÏ£¬½øÈësqlplusµÄ±à¼×´Ì¬ÖÐ
£¨1£©²é¿´¿ØÖÆÎļþµÄÄÚÈÝ£º
SQL> DESC v$controlfile
Ãû³Æ &n ......
oracleÐÐתÁÐͨÓùý³Ì(ת)
»·¾³oracle 10g
¹¤×÷¹Øϵ,³£×öЩÐÐתÁб¨±í,±¨±íͨ³£²»ÊÇÔÚ´óÊý¾Ý¼¯ºÏÉÏ´¦Àí.
ËùÒÔдÁ˸ö¹ý³Ì.
±¾¹ý³Ì±È½ÏÊʺÏÔÚÓÚÐèÒª¶¯Ì¬Êä³ö±¨±íµÄµØ·½,ÀýÈçwebÖÐ.
²»ÊǺÜÍêÃÀ,µ«ÒѾ¿ÉÒÔ½â¾ö¾ø´ó²¿·ÖµÄÎÊÌâ.
create or replace function func_RowToCol(
viewName Varchar2,
grpCols Varchar2,
colC ......
ÔÚLinuxÏ°²×°Oracle Database 9i
2009Äê05ÔÂ11ÈÕ ÐÇÆÚÒ» 20:49
http://www0.ccidnet.com/tech/guide/2001/11/20/58_3761.html
Oracle9i 2000Äê10ÔÂÔÚOracle Open WorldÉÏ·¢²¼£¬Îª Oracle Êý¾Ý¿â¡¢Ó¦Ó÷þÎñÆ÷ºÍ¿ª·¢¹¤¾ßÒý½øÁËÐí¶àй¦ÄÜ¡£Oracle9iÊÇÒµ½çµÚÒ»¸öÍêÕû¡¢¼òµ¥µÄÓÃÓÚ»¥ÁªÍøµÄÐÂÒ»´úÖÇÄÜ»¯µÄ¡¢Ð×÷¸÷ÖÖÓ¦ÓõÄÈí ......