³ÌÐòԱѧ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Сʱ£¬¾ßÌå¸ù¾ÝЧÂÊ×Ô¶¨£» ѧÀú²»ÏÞ£¬ÔÚ Ö°»òѧÉú½Ô¿É£»ÇÚ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
¼ÙÉè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; ......