³ÌÐòԱѧoracle,Êdzõѧ,¿´Ê²Ã´ÊéºÃ?
¸Ðл
µ½µçÂ¿ÍøÉÏϵãÊÓÆµ¿´¿´£¬ºÜ¶àÈëÃż¶±ðµÄÊÓÆµµÄ£¬±È¿´ÊéÓÐÒâ˼¡£ ÏÈ¿´»ù´¡µÄÈëÃŵ쬱ÈÈç¹ÜÀíÖ®À࣬ÊìϤoracleµÄ½á¹¹¡£ È»ºó¿´sqlÓÅ»¯Ö®Àà¡£ÒýÓà ÏÈ¿´»ù´¡µÄÈëÃŵ쬱ÈÈç¹ÜÀíÖ®À࣬ÊìϤoracleµÄ½á¹¹¡£ È»ºó¿´sqlÓÅ»¯Ö®Àà¡£ ÕâÑùѧÂð,ѧSQL SERVERµÄʱºòÖ±½ÓÉÏÀ´¾ÍDML DDLµÄ...ÄãÍÆ¼öµãÊé°É?ÒýÓà ÏÈ¿´»ù´¡µÄÈëÃŵ쬱ÈÈç¹ÜÀíÖ®À࣬ÊìϤoracleµÄ½á¹¹¡£ È»ºó¿´sqlÓÅ»¯Ö®Àà¡£ Çë½éÉܵãÓÃjava²Ù×÷oracleµÄ±à³Ì·½ÃæµÄÊ鏸ÎÒ£¬ÄÄÌìÈ¥Õû¼¸±¾»ØÀ´³å³åµç¡£ÐÞÁ¶Ò»Ï£¬Îª´º½Úºóµ½Êг¡ÉÏÈ¥¿´¿´ÐÐÇ飬Ôö¼ÓµãíÀÂë¡£ÒýÓà ÒýÓà 2 Â¥ crazylaa µÄ»Ø¸´: ÏÈ¿´»ù´¡µÄÈëÃŵ쬱ÈÈç¹ÜÀíÖ®À࣬ÊìϤoracleµÄ½á¹¹¡£ È»ºó¿´sqlÓÅ»¯Ö®Àà¡£ Çë½éÉܵãÓÃjava²Ù×÷oracleµÄ±à³Ì·½ÃæµÄÊ鏸ÎÒ£¬ÄÄÌìÈ¥Õû¼¸±¾»ØÀ´³å³åµç¡£ÐÞÁ¶Ò»Ï£¬Îª´º½Úºóµ½Êг¡ÉÏÈ¥¿´¿´ÐÐÇ飬Ôö¼ÓµãíÀÂë¡£ javaôjava±à³Ì˼ÏëÂï,²»¹ýÒª¶®Ò»µãJava¿´ÆðÀ´ÈÝÒ×µã,oracle³õѧÕßÎÒÒ²²»ÖªµÀÂòʲô,Çó½â ÎÒÏÖÔÚÊÇjava+oracle¶¼ÔÚ×ö£¬ËùÒÔÏëÕÒµãÕâ2¸ö¼¼ÊõµÄ¼¯ºÏµãµÄÊé¿´£¡ ¼±Æ¸ ÍøÂç¼æÖ°ÈËÔ±£¬100Ôª/Ì죡¹¤×ÊÈÕ½á http://www.coien.cn/?49653.htm ÕÐÆ¸ÈËÊý: Èô¸ÉÃû ¡¡Ð½×Ê´ýÓö: ¹¤×÷ÿÌì3Сʱ£¬100Ôª/Ì칤×ÊÿÈÕÖ§¸¶£» ¸ÚλÃèÊö: ¸ºÔð¹«Ë¾ËùÒªÇóµÄÐÅÏ¢»Ø¸´¹¤×÷£¨ÓÐÄÚÈÝÑù°æ£©£¬¹¤×÷µØµã²»ÏÞ£¬×¨¼æÖ°¾ù¿É£¡ ӦƸҪÇó: ÉÏÍøÊìÁ·£¬Æ½¾ùÿÌ칤×÷ͶÈëÔ¼3Сʱ£¬¾ßÌå¸ù¾ÝЧÂÊ×Ô¶¨£» ѧÀú²»ÏÞ£¬ÔÚ Ö°»òѧÉú½Ô¿É£»ÇÚ
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......