ÇóÖúoracleÈëÃÅ֪ʶ
±¾ÈËÖ»ÊìϤsql server,×î½üÏÂÔØÁËÒ»¸öoracle,ºÍPL/SQL,¿ÉÊÇÆô¶¯ºóÒªÊäÈëÕʺźÍÃÜÂë,ÎҼǵÃÓÃsa×÷ΪÃÜÂë,ÕʺÅÎÒÊäÈëÁË orcl,¿ÉÊÇÁ¬½Ó²»ÉÏ,ÇóÖúÈçºÎÁ¬½ÓºÍÏà¹ØµÄ×î»ù±¾ÈëÃÅ×ÊÁÏ,лл
Oracle°²×°·ÖΪ·þÎñ¶ËºÍ¿Í»§¶Ë Èç¹ûÄãÊǽøÈ˼ÒÒѾ½¨ºÃµÄ¿â,Ò²¾ÍÊǷDZ¾»úµÄÊý¾Ý¿â,ÄÇôװ¿Í»§¶Ë. Èç¹ûÄã½ø×Ô¼ºµÄ,ÄÇô¿Í»§¶ËºÍ·þÎñ¶Ë¶¼ÐèҪװ.²¢ÇÒÒª°²×°×Ô¼ºµÄÊý¾Ý¿â.ÔÚ¿ªÊ¼->³ÌÐò->Oracle->ÅäÖúÍÒÆÖ²¹¤¾ß->Database Conif....Ï´´½¨Êý¾Ý¿â. ´´½¨¹ý³ÌÖÐ»á¸øÄãÒ»×éÕÊ»§,ÈÃÄãÌîдÃÜÂë,ÆäÖаüÀ¨sysºÍsysmanµÈ.È»ºóÊäÈëÃÜÂë,¼Çס¾ÍºÃÁË. È»ºóÓÃPLSQLµÇ½. Óû§ÃûÊÇsys ÃÜÂëÊÇÄã¸ÕÊäÈëµÄÃÜÂë sid(Ò²¾ÍÊÇ·þÎñÃû)ΪÄã×°Êý¾Ý¿âʱÈÃÄãÌîµÄ"È«¾ÖSID"(¾ßÌåÎÒÍü¼ÇÁ˾ÍÊÇÈ«¾ÖÊý¾Ý¿â»¹ÊÇʲôµÄ) È»ºóÄã¾Í¿ÉÒÔÒÔDBAµÄÉí·ÝµÇ½ÁË »òÕßÄãÔÚcmdÀï´òÈçÏÂÃüÁî sqlplus /nolog È»ºóÔÙ´ò connect sys/ÃÜÂë as sysdba Ò²¿ÉÒÔ Ð»Ð»,¿´À´ÎÒҪжµôÖØÐ°²×°ÁË,ÎÒÈ¥ÊÔÊÔÒýÓà лл,¿´À´ÎÒҪжµôÖØÐ°²×°ÁË,ÎÒÈ¥ÊÔÊÔ ²»Êǰɣ¬ÄãÏëжµô֨װ£¡ÎÒ×°ÁËÊ®¼¸±é¶¼Ã»×°ÉÏ£¡ oracleÐ¶ÔØ±È½ÏÂé·³£¬ÒªÉ¾³ý×¢²á±íÀïµÄһЩ¼üÖµ ÎªÊ²Ã´ÒªÖØ×°°¡£¿ ²»Ò»¶¨Ö»ÓÐ֨װ°É£¬ÏÂÒ»²½°²×°¾ÍÐÐÁË¡£ ¼ì²éÊÇ·ñ´ò¿ªoracle¼àÌý.ÒýÓà ÒýÓà 2 Â¥ nj_zx999 µÄ»Ø¸´: лл,¿´À´ÎÒҪжµôÖØÐ°²×°ÁË,ÎÒÈ¥ÊÔÊÔ ²»Êǰɣ¬ÄãÏëжµô֨װ£¡ÎÒ×°ÁËÊ®¼¸±é¶¼Ã»×°ÉÏ£¡ ºÇºÇ£¬Í¬¸Ð£¬ÎÒҲŪÁËÁ½Ìì²Å×°ÉÏ {
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬ -A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
with adod_dict do begin close; commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿ ¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼ Ö麣ÄDZßËÆºõûÉîÛÚºÃ. Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮ ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update Caused ......