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

Oracle Êý¾Ý¿âµÄ°²×°

 
   ×°ÁËÒ»Ò¹µÄÈí¼þ£¬ÏÈÊÇMySQL£¬myEclipse,Oracle ,²»¶ÏµÄ³ö´í£¬OracleServise²»ÄÜÆô¶¯£¬ºÜÊÇ·³ÈË£¬Ð¶ÔØÁËOracelÁ½´Î£¬ÓÖ֨װ£¬´íÎóµÃµ½Ò»Ð©½â¾ö£¬×¢²á±í³öÏÖÁ˺öàµÄÎÊÌ⣬ÒÔǰÔÚÐ¶ÔØÈí¼þµÄʱºò£¬¶¼Ã»ÓÐÓÃרÓõŤ¾ß£¬×¢²á±íÒ»ÍÅÂÒ£¬ÕæÊÇÏ൱µÄºó»Ú£¬ÏÖÔÚ¿´À´ÒªÏë¸Ä¹ýÀ´È·ÊµÊǺÜÄѵÄÀ²£¡ÒÔºóÕâ·½ÃæÒª¶à¼ÓµÄ×¢Òâ¿©¡£
      ÏÖÔÚÖÕÓڴ󹦸æ³É£¬ºÃÏë¿Þ£¡ ÕâÊÇÎÒµÚÒ»´ÎÕâÑùÏàÐÅ×Ô¼º£¬Ð»Ð»ÍøÓѵÄһЩ°ï£¬http://blog.csdn.net/xiaoyao6650/archive/2009/03/15/3989484.aspx£¬½ñÌìÓÖ×°ÁËVS2008£¬ÀÏÊÇÌø³öWEB×é¼þ°²×°Ê§°Ü£¬ÆøËÀÁË£¬
ÏÖÔÚÖÕÓÚ¸ãºÃÁË£¬Ô­À´ÊÇoffice_zh-cnµÄÎÊÌ⣬ÖÕÓڵõ½Á˽â¾ö¡£
       ÖÐÎç·¸Á˸ö´íÎó£¬ÌýÐÅÍøÓѵķ½·¨£¬ÐÞ¸ÄÁËÓû§µÄÕË»§£¬×îºó½øÈëF8²ÅµÃ½â¾ö£¬¿´À´µÃ×Ô¼º¶à¶¯¶¯ÄÔ×Óȥ˼¿¼°¡£¡
        ¾­ÀúÁËÕâЩÊÂÇ飬¸ü¼Ó¼á¶¨ÁË×Ô¼ºÒª×ߵķ£¬Chang,ÎÒÃÇÒ»ÆðŬÁ¦°É£¡ÏàÐÅ£¬ÎÒÏàÐÅÎÒÐеģ¬ÄãÒ²Ò»¶¨»áµÄ£¬²»ÊǵÄô£¬MyLove !


Ïà¹ØÎĵµ£º

OracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðò

ÎÒÔÚ¹¤×÷ÖÐÔÚOracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðòʱ£¬ÓÃorder by ±íÃû.datatime desc ×ÜÊÇʵÏÖ²»ÁË¡£
²»¹ý×îºóÎÊÑî¾é×îºóºÍÎÒ˵¿ÉÒÔ°ÑÎÒÃDzéѯµÄ×ܸösqlÓï¾ä×öΪһ¸ö±íÀ´ÅÅÐò£º
select rownum,aa.* from (....  order by ±íÃû.datatime desc ) aa ......

´´½¨oracle dblink

create database link user_auth
¡¡¡¡ connect to user_auth identified by user_auth
¡¡¡¡ using  '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.236)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=develop1)))'; ......

Oracle²âÊÔ´æ´¢¹ý³ÌÁ½ÖÖ·½Ê½

ÔÚ³õѧOracleʱ£¬Ð´ÁËÒ»¸ö´æ´¢¹ý³Ì£¬Ãû³ÆÊÇ£ºPROC_GET_BILL£¬Èý¸ö²ÎÊý£¬µÚ1£¬3ÊÇin²ÎÊý£¬µÚ2ÊÇout²ÎÊý£¬Ð´ÍêÖ®ºó£¬Ïë²âһϣ¬½á¹û·¢ÏÖÍøÉÏÓжàÖÖ·½Ê½£¨ÆäÖØÒªÊÇÏÂÃæÕâÁ½ÖÖ£¬Ö»ÊÇд·¨²»Í¬¶øÒÑ£©£¬¸Õ¿ªÊ¼°ÑÁ½ÖÖ±äÁ¿¶¨Ò巽ʽ¸ã´íÁË£¬Ò»Ö±Ö´Ðв»¹ý£¬¾­ÂýÂý³¢ÊÔ£¬µÃµ½ÁËÏÂÃæÁ½ÖÖд·¨£¬Ï£ÍûÏñÎÒÕâÑù³õѧÕßÉÙ×ßÍä·£¬Ö±½Ó¸ãÇåÁ½ÖÖ· ......

ORACLE³£Óù¦ÄÜ

-- ɾ³ýÖØ¸´¼Ç¼
DELETE from mytable t1 WHERE ROWID > (SELECT MIN (ROWID) from mytable t2 WHERE t1. key = t2.key);
-- µ±Ç°ÈÕÆÚ
SELECT TO_CHAR(SYSDATE, 'yyyy-MM-dd') from DUAL;
-- ÉÏÔµ±Ç°ÈÕÆÚ
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,
-1), 'yyyy-MM-dd') from DUAL;
-- ÏÂÔµ±Ç°ÈÕÆÚ
SELECT
TO_C ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ