Çë½ÌÓÃJDBC´´½¨Ò»¸öoracleµÄÊý¾Ý¿â
ÇëÎÊÓÃJDBC´´½¨Ò»¸öoracleµÄÊý¾Ý¿â~~Ó¦¸ÃÒªÔõô×öÄØ£¿£¿ÊÇÊý¾Ý¿âŶ~~²»ÊDZíŶ~~
×Ô¼º¶¥Ò»ÏÂ~~~ ÄãÊÇÔÚÎÊÎÊÌâÂ𣿣¿£¿£¿£¿£¿£¿£¿ ѧϰ²»ÊÇÕâÑùѧµÄ£¡ ÄãÏÈÈ¥×Ô¼ºÕÒ×ÊÁÏ¿´¿´£¬ÕÕ×Å×ÊÁÏÉϲÙ×÷³ö²»À´£¬ÔÙÀ´ÎÊ£¬ÎʵþßÌåµã¡£ ÕâÖÖÎÊ·¨Ì«¿Õ·º£¬±ðÈËÒª´ðÒ²Ö»ÄܸøÄã¸´ÖÆÕ³ÌùÒ»´ó¶ÎʹÓÃÈëÃÅ£¬Ã»ÒâÒåµÄ¡£ ÊÇÒª´´½¨Ò»¸öÊý¾Ý¿âʵÀýô£¿ ÍøÉÏÄÇЩÎÒÕÒÁ˺ܶàÁË¡£¡£¡£ÕÒµ½µÄ¾ø´ó²¿·Ö¶¼ÊÇÔõôÁ¬½ÓµÄ~~Á¬½ÓµÄ²¿·ÖÒѾѧ»áÁË~~¿ÉÊǾÍÊÇÔõÑù½¨¿â²»ÖªÔõôŪ~~Ò²ÕÒÁËÊ飬°´ÊéÀïµÄÒ»ÌõÌõµØÅª¡£¡£Ò²Êdzö´í~~~ËùÒÔ²ÅÏëÎÊÏÂÄܲ»ÄÜÌṩ±È½ÏÏêϸµÄ²½Öè~~ŪÁ˺ü¸ÌìµÄ°¡~~~ »ØÒ»ÏÂ4Â¥~~ ÎÒÊÇÏ뽨һ¸öеÄÊý¾Ý¿â~~²»ÊÇʵÀýŶ~~ »¹¸öÕæ¿ÉÒÔ£¿ÒýÓà »¹¸öÕæ¿ÉÒÔ£¿ ÓÃJAVA²»¿ÉÒÔʵÏÖµÄÂ𣿣¿½¨±íÄÇЩÎһᡣ¡£¾ÍÊǽ¨Êý¾Ý¿âʱ¼´Ê¹ÓÃÊÖ¹¤½¨Ò²ÀÏÊÇʧ°Ü~~½øcmdºó²úÉúʵÀýºó£¬ÀÏÊÇ˵ÎÒÃÜÂë´íÎó~~~ÃÜÂëû´í°¡~~ÊÔÁ˺ܶà±éÁË¡£¡£ Oracle ÊÇÒÔ schema À´¹ÜÀíµÄ£¬¿ÉÒÔ¼òµ¥µØÈÏΪÊǰ´Óû§À´¹ÜÀíµÄ£¬¶ø²»Êǰ´Êý¾Ý¿âÀ´¹ÜÀíµÄ¡£ ÔÚ Oracle ÖÐÖ´ÐÐ CREATE DATABASE ÄÇÊÇÒ»ÏîºÜ¸´ÔӵŤ×÷ÁË£¬Oracle ÐèÒª´´½¨ºÜ¾ÃÄØ¡£Ò»°ã°²×° Oracle ·þÎñ¶Ëºó»á×Ô¼ºÐ½¨Ò»¸öĬÈϵÄÊý¾Ý¿â¡£ oracleÖеÄÊý¾Ý´´½¨Ê±ºÜÂé·³µÄ£¬²»ÏñmysqlÖУ¬Ö´ÐÐÁËcreate database¾ÍÐУ¬Äã×îºÃÓÃoracleµÄ¹ÜÀí¶ËÈ¥´´½¨ Ŷ~~лл¥Éϵĸ÷λÁË~~Ô±¾»¹ÒÔΪ¿ÉÒÔÓÃJAVA´úÂëʵÏÖ~~~ DML
Ïà¹ØÎÊ´ð£º
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
ÎÒ°²×°ÁËoracle 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬ µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´ ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......