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

Oracle Cursor

 1£¬Ê²Ã´ÊÇÓαꣿ
 ¢Ù´Ó±íÖмìË÷³ö½á¹û¼¯£¬´ÓÖÐÿ´ÎÖ¸ÏòÒ»Ìõ¼Ç¼½øÐн»»¥µÄ»úÖÆ¡£
   
 ¢Ú¹ØÏµÊý¾Ý¿âÖеIJÙ×÷ÊÇÔÚÍêÕûµÄÐм¯ºÏÉÏÖ´Ðеġ£
  ÓÉ SELECT Óï¾ä·µ»ØµÄÐм¯ºÏ°üÀ¨Âú×ã¸ÃÓï¾äµÄ WHERE ×Ó¾äËùÁÐÌõ¼þµÄËùÓÐÐС£ÓɸÃÓï¾ä·µ»ØÍêÕûµÄÐм¯ºÏ½Ð×ö½á¹û¼¯¡£
     Ó¦ÓóÌÐò£¬ÓÈÆäÊÇ»¥¶¯ºÍÔÚÏßÓ¦ÓóÌÐò£¬°ÑÍêÕûµÄ½á¹û¼¯×÷Ϊһ¸öµ¥Ôª´¦Àí²¢²»×ÜÊÇÓÐЧµÄ¡£
     ÕâЩӦÓóÌÐòÐèÒªÒ»ÖÖ»úÖÆÀ´Ò»´Î´¦ÀíÒ»ÐлòÁ¬ÐøµÄ¼¸ÐС£¶øÓαêÊǶÔÌṩÕâÒ»»úÖÆµÄ½á¹û¼¯µÄÀ©Õ¹¡£
     ÓαêÊÇͨ¹ýÓαê¿âÀ´ÊµÏֵġ£Óαê¿âÊdz£³£×÷ΪÊý¾Ý¿âϵͳ»òÊý¾Ý·ÃÎÊ API µÄÒ»²¿·Ö¶øµÃÒÔʵÏÖµÄÈí¼þ£¬
     ÓÃÀ´¹ÜÀí´ÓÊý¾ÝÔ´·µ»ØµÄÊý¾ÝµÄÊôÐÔ£¨½á¹û¼¯£©¡£ÕâЩÊôÐÔ°üÀ¨²¢·¢¹ÜÀí¡¢ÔÚ½á¹û¼¯ÖеÄλÖᢷµ»ØµÄÐÐÊý£¬
     ÒÔ¼°ÊÇ·ñÄܹ»ÔÚ½á¹û¼¯ÖÐÏòǰºÍ/»òÏòºóÒÆ¶¯£¨¿É¹ö¶¯ÐÔ£©¡£
     Óαê¸ú×Ù½á¹û¼¯ÖеÄλÖ㬲¢ÔÊÐí¶Ô½á¹û¼¯ÖðÐÐÖ´Ðжà¸ö²Ù×÷£¬ÔÚÕâ¸ö¹ý³ÌÖпÉÄÜ·µ»ØÖÁԭʼ±í£¬Ò²¿ÉÄܲ»·µ»ØÖÁԭʼ±í¡£
     »»¾ä»°Ëµ£¬Óαê´Ó¸ÅÄîÉϽ²»ùÓÚÊý¾Ý¿âµÄ±í·µ»Ø½á¹û¼¯¡£
     ÓÉÓÚËüָʾ½á¹û¼¯Öеĵ±Ç°Î»Öà £¬¾ÍÏñ¼ÆËã»úÆÁÄ»ÉϵĹâ±êָʾµ±Ç°Î»ÖÃÒ»Ñù£¬“Óαê”Óɴ˵ÃÃû¡£
2£¬ÓαêÓÐʲô×÷Óã¿
 ¢ÙÖ¸¶¨½á¹û¼¯ÖÐÌØ¶¨ÐеÄλÖá£
 ¢Ú»ùÓÚµ±Ç°µÄ½á¹û¼¯Î»ÖüìË÷Ò»ÐлòÁ¬ÐøµÄ¼¸ÐС£
 ¢ÛÔÚ½á¹û¼¯µÄµ±Ç°Î»ÖÃÐÞ¸ÄÐÐÖеÄÊý¾Ý¡£
 ¢Ü¶ÔÆäËûÓû§Ëù×öµÄÊý¾Ý¸ü¸Ä¶¨Ò岻ͬµÄÃô¸ÐÐÔ¼¶±ð¡£
        ¢Ý¿ÉÒÔÒÔ±à³ÌµÄ·½Ê½·ÃÎÊÊý¾Ý¿â¡£
    
3£¬ÎªÊ²Ã´±ÜÃâʹÓÃÓαꣿ
 ¢ÙÔÚ´´½¨Óαêʱ£¬×îÐèÒª¿¼ÂǵÄÊÂÇéÊÇ£¬“ÊÇ·ñÓа취±ÜÃâʹÓÃÓαꣿ”
  ÒòΪÓαêµÄЧÂʽϲÈç¹ûÓαê²Ù×÷µÄÊý¾Ý³¬¹ý1ÍòÐУ¬ÄÇô¾ÍÓ¦¸Ã¸Äд£»
  Èç¹ûʹÓÃÁËÓα꣬¾ÍÒª¾¡Á¿±ÜÃâÔÚÓαêÑ­»·ÖÐÔÙ½øÐбíÁ¬½ÓµÄ²Ù×÷¡£
4£¬OracleÓαêµÄÀàÐÍ£¿
 ¢Ù¾²Ì¬Óα꣺½á¹û¼¯ÒѾ­È·Êµ£¨¾²Ì¬¶¨Ò壩µÄÓαꡣ·ÖΪÒþʽºÍÏÔʾÓαꡣ
  ¢ÅÒþʽÓα꣺ËùÓÐDMLÓï¾äΪÒþʽÓα꣬ͨ¹ýÒþʽÓαêÊôÐÔ¿ÉÒÔ»ñÈ¡SQLÓï¾äÐÅÏ¢¡£
  ¢ÆÏÔʾÓα꣺Óû§ÏÔʾÉùÃ÷µÄÓα꣬¼´Ö¸¶¨½á¹û¼¯¡£µ±²éѯ·µ»Ø½á¹û³¬¹ýÒ»ÐÐʱ£¬¾ÍÐèÒªÒ»¸öÏ


Ïà¹ØÎĵµ£º

Oracle ·ÖÒ³Óï¾ä£¬´æ´¢¹ý³Ì

select * from (select t.*,rownum rn from (select * from emp) t where rownum<=10) where rn>=6;
´´½¨·ÖÒ³½á¹û¼¯µÄÓαê
create or replace package fenyepackage as
type testcursor is ref cursor;
end fenyepackage;
´´½¨·ÖÒ³´æ´¢¹ý³Ì
create or replace procedure fenye3(
tableName varchar2, --±íÃû ......

ORACLEÖиø±í¡¢ÁÐÔö¼Ó×¢ÊÍÒÔ¼°¶ÁȡעÊÍ

ÔÚORACLEÖиø±í¡¢ÁÐÔö¼Ó×¢ÊÍÒÔ¼°¶ÁȡעÊÍ
1¡¢¸ø±íÌî¼Ó×¢ÊÍ£ºSQL>comment on table ±íÃû is '±í×¢ÊÍ";
2¡¢¸øÁмÓ×¢ÊÍ£ºSQL>comment on column ±í.ÁÐ is 'ÁÐ×¢ÊÍ';
3¡¢¶ÁÈ¡±í×¢ÊÍ£ºSQL>select * from user_tab_comments where comments is not null;
4¡¢¶ÁÈ¡ÁÐ×¢ÊÍ£ºSQL>select * from user_col_commnents wh ......

Aix 5.3ÏÂ×Ô¶¯±¸·ÝOracle¶à¸öʵÀý£¬²¢ÉÏ´«ÖÁFTP·þÎñÆ÷

Ò»¡¢Ð½¨databack.shÎļþ£¬´æ·ÅĿ¼/opt/databack/
#Êý¾Ý¿âÓû§×ÊÁÏ
USERNAME=Êý¾Ý¿âÓû§Ãû(ÐÅÏ¢Òþ²Ø)
PASSWORD=Êý¾Ý¿âÃÜÂë(ÐÅÏ¢Òþ²Ø)
#FTP·þÎñÆ÷ÐÅÏ¢
FTP_SERV=FTP·þÎñÆ÷(ÐÅÏ¢Òþ²Ø)
FTP_USER=FTPÓû§Ãû(ÐÅÏ¢Òþ²Ø)
FTP_PASS=FTPÃÜÂë(ÐÅÏ¢Òþ²Ø)
FTP_DIR=FTPĿ¼(ÐÅÏ¢Òþ²Ø)
#±¸·ÝĿ¼
BACKUP_DIR=/opt/databack
#¸ ......

oracle 10g em¡¢isqlplus·ÃÎʲ»Á˵ÄÎÊÌâ½â¾ö£¨»ã±à£©

Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§                     http://ip:5560/isqlplus
DBAÓû§   &nb ......

ORACLEËøµÄ¹ÜÀí

ORACLEÀïËøÓÐÒÔϼ¸ÖÖģʽ:
0£ºnone
1£ºnull ¿Õ
2£ºRow-S Ðй²Ïí(RS)£º¹²Ïí±íËø£¬sub share
3£ºRow-X ÐжÀÕ¼(RX)£ºÓÃÓÚÐеÄÐ޸ģ¬sub exclusive
4£ºShare ¹²ÏíËø(S)£º×èÖ¹ÆäËûDML²Ù×÷£¬share
5£ºS/Row-X ¹²ÏíÐжÀÕ¼(SRX)£º×èÖ¹ÆäËûÊÂÎñ²Ù×÷£¬share/sub exclusive
6£ºexclusive ¶ÀÕ¼(X)£º¶ÀÁ¢·ÃÎÊʹÓã¬exclusive ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ