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

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬ÔÚdaoÖÐдºÃÁËÁ¬½Ó£º
    È»ºóдºÃÁ˲éѯҳÃ棺
    ÔÙдºÃservlet£¬µ±È»ÎÒµÄbeanÊÇ֮ǰ¾ÍдºÃµÄ£¬ºÜ¼òµ¥£¬ºÜÈÝÒ×Àí½â£¬Ò²¾Í²»ÔÚÕâÀïչʾ£¬ºÙºÙ£¡
    ×îºóÔÙдºÃ²éѯÓï¾ä£¬µ±È»£¬Õâ¸ö¶«¶«Ò²ÊÇÔÚdaoÖÐд¡£
    дÍêÕâЩ»ù±¾×¼±¸Ö®ºóÎҾͿªÊ¼µ÷ÊÔÀ²£¬ºÙºÙ¡£
    µ«ÊÇ£¬µ±Í·Ò»°ô£¬ÂíÉÏÓöµ½Ò»¸ö´íÎó£º
    È»ºó£¬¾ÍÊÇ·è¿ñµÄÉÏÍø²éÕÒ£¬ºÙºÙ£¬ºÃÐÄÈ˺ܶ࣬Ȼºó¾Í½â¾öÎÊÌ⣬½â¾ö²½ÖèÈçÏ£º
    1¡¢Ê×ÏÈ¿´URLºÍ¶Ë¿ÚÊÇ·ñ´íÎó
         ¾­¼ì²é£¬Oracle·þÎñÊÇ¿ªÆôµÄ£¬Êý¾Ý¿âÊÇÆô¶¯µÄ£¬ãç¿ÚÒ²ÊÇÕýÈ·µÄ£¬µ±È»IP¾Í²»ÓÃ˵À²¡£
    2¡¢¼ì²éÊÇ·ñÊÇÒòΪ·À»ðǽµÄÔ­Òò½«¶Ë¿Ú×èÖ¹¿©£¬È»ºóÖØÆô£¬½á¹û»¹ÊÇʧ°Ü
    3¡¢¼ì²éÊý¾Ý¿â¼àÌýÊÇ·ñ¿ªÆô
         ¿ªÊ¼ → ÔËÐÐ→ ÊäÈëCMD→  ½øÈëDOSÃüÁîÌáʾ½çÃæÇÃÈ룺
lsnrctl½øÈë
    È»ºó²é¿´×´Ì¬ÊÇ·ñ¿ªÆô£ºLSNRCTL>status,µÃµ½
   Õâ¾ÍÖ¤Ã÷ÁË£¬Êý¾Ý¿â¼áͦûÓдò¿ª£¬µ±È»£¬Á¬½ÓÊý¾Ý¿â¾ÍÊDz»µÃ³É¹¦µÄ£¬½ÓÏÂÀ´¾Í´ò¿ªÊý¾Ý¿â¼àÌý
   ºÙºÙ£¬ÒªÊÇÏÔʾµ½ÕâÒ»²½£¬ÄÇôÁ¬½ÓÊý¾Ý¿âÒ²¾Í³É¹¦À²£¡
   Ò²µ±È»À²£¬½ñÌìµÄÁ¬½Ó¾Í³É¹¦ÁË£¬ºÙºÙ£¡£¡£¡
    


Ïà¹ØÎĵµ£º

oracle 10gÈçºÎ¹Ø±ÕºÍ´ò¿ª×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢

http://www.51testing.com/?uid-16403-action-viewspace-itemid-101605
 Ò»¡¢ORACLE10g×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢--×Ô¶¯analyze
´ÓOracle Database 10g¿ªÊ¼£¬OracleÔÚ½¨¿âºó¾ÍĬÈÏ´´½¨ÁËÒ»¸öÃûΪGATHER_STATS_JOBµÄ¶¨Ê±ÈÎÎñ£¬ÓÃÓÚ×Ô¶¯ÊÕ¼¯CBOµÄͳ¼ÆÐÅÏ¢¡£
Õâ¸ö×Ô¶¯ÈÎÎñĬÈÏÇé¿öÏÂÔÚ¹¤×÷ÈÕÍíÉÏ10£º00-6£º00ºÍÖÜÄ©È«Ìì¿ªÆ ......

oracleͳ¼ÆÐÅÏ¢ÊÕ¼¯

http://www.51testing.com/?uid-16403-action-viewspace-itemid-101604
 Í³¼ÆÐÅÏ¢°üÀ¨ÏÂÃ漸Àࣺ
 
±íͳ¼Æ£º°üÀ¨¼Ç¼Êý¡¢blockÊýºÍ¼Ç¼ƽ¾ù³¤¶È¡£
ÁÐͳ¼Æ£ºÁÐÖв»Í¬ÖµµÄÊýÁ¿£¨NVD£©¡¢¿ÕÖµµÄÊýÁ¿ºÍÊý¾Ý·Ö²¼£¨HISTOGRAM£©¡£
Ë÷Òýͳ¼Æ£ºË÷ÒýÒ¶¿éµÄÊýÁ¿¡¢Ë÷ÒýµÄ²ãÊýºÍ¾Û¼¯Òò×Ó£¨CLUSTERING FACTOR£©¡£
ϵͳͳ¼Æ ......

CentOS5.2ÉÏ°²×°Oracle 10g 10.0.2.1.0

×¢Ò⣺ΪSWAP·ÖÅäµÄ¿Õ¼äÒª³¬¹ý1G£¬Òª²»È»ºóÃæ×°Oralce»áÒòΪ¿Õ¼ä²»×ã¶øÎÞ·¨°²×°¡£²¢ÇÒÒª¹Ø±Õ·À»ðǽ£¬¹Ø±ÕSELIINUX
ÐÞ¸ÄhostÎļþ
Hosts File
# vi /etc/hosts
192.168.10.10 oracle oracle.localdomain oracle
127.0.0.1 oracle localhost.localdomain localhost
×¢Ò⣺ÄãÒª°Ñ192.168.10.10¸Ä³ÉÄã×Ô¼ºµÄIP£¬ÎÒÕâÀïÖ»ÊÇ ......

OracleÊý¾Ýµ¼³öµ½DBFµÄÎÊÌâ

 OracleÊý¾Ýµ¼³öºÜ¼òµ¥£¬µ«ÎªÁËÌá¸ßËٶȣ¬ÎÒÒ»°ã²»Ö±½Óµ¼³ö³ÉDBF£¬¶øÊÇÏȵ¼³ö³ÉCSV¸ñʽµÄÎı¾Îļþ¡£
½ñÌì¾ÍÓöµ½Ò»¸öÎÊÌ⣬µ¼³öµÄcsvÔÚת»»³Édbfʱ³öÏÖÁ˺ܶà¿ÕÐС£¾­¹ý²éÕÒÎÊÌ⣬·¢ÏÖÊÇ×Ö¶ÎÖк¬Óл»Ðзûµ¼Ö¡£
ʹÓÃ
select Replace(zsyj,chr(13)||chr(10),'')  as SXPD  from TableName
½â¾öÎÊÌâ¡£ ......

Oracle WrapʹÓ÷½·¨

OracleÌṩWrap¹¤¾ß£¬¿ÉÒÔÓÃÓÚ¼ÓÃÜÄãµÄPackageµÈ.
²»¹ýÐèҪעÒâµÄÊÇ£¬¼ÓÃܺóµÄ´úÂëÎÞ·¨½âÃÜ£¬ÄãÐèÒª±£¹ÜºÃÄãµÄÔ´´úÂë¡£
ÒÔÏÂÊǸöÀý×Ó:
1.Ô´´úÂë
create or replace function get_rowid
(l_rowid in varchar2)
return varchar2
is
ls_my_rowid varchar2(200);
rowid_type number;
ob ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ