ÇëÎÊÒ»¸ö¼òµ¥µÄoracleµÄÎÊÌâ
ÎÒ×î½üÔÚѧoracle£¬¸Õ×°Íêoracle£¬È»ºóÓöÀÁ¢Æô¶¯½øÈ¥ÁË£¬ÓÃsqlÓï¾ä½¨Á˸ö±í study,ÕÒÁ˰ëÌì²Å·¢ÏÖ±íÔÚ·½°¸µÄsysÀïÃæ£¬ÎÒÖ÷ÒªÊÇÏëÔÚoralceÀィһ¸öÊý¾Ý¿â£¬È»ºó½¨¸ö±í£¬ÔÙÈ»ºóÈ¥ÓÃ.netÀ´Á¬oracleÊý¾Ý¿â£¬¶Ô±í½øÐÐÔöɾ¸ÄµÄ²Ù×÷,ÇëÎÊÎÒ¸ÃÔõôÑù½¨±í£¿£¿£¬ÊÇÔÚ½¨±íǰҪÏȽ¨±ðµÄ¶«Î÷Â𣿣¿»¹ÓÐÎÒÓÃ.netÁ¬oracleµÄʱºòÒªÌî·þÎñÆ÷Ãû£¬ÇëÎÊÕâ¸ö·þÎñÆ÷ÃûÔÚÄÄ£¿£¿
Ê×ÏÈÄãÒª´´½¨Ò»¸öschema£¬×îºÃÊÇÓÃÄãÓ¦ÓóÌÐòµÄÓ¢ÎÄËõдÃû´´½¨,Àý net select * from net.study
È»ºóÊÚÏàÓ¦µÄȨÏÞ£¬½¨±í,ɾ³ý±í,ÐÞ¸Ä±í¡£ create table,drop table,alter table....
·þÎñÆ÷ÃûÊÇÄã´´½¨Êý¾Ý¿âʱµÄ·þÎñÃû£¬ ËÑ tnsnames.ora Îļþ£¬ÀïÃæ»áÓÃÏÔʾ
oralceÊÇÒªÏȽ¨¿â£¬È»ºó½¨±í¿Õ¼ä£¬×îºó²ÅÊǽ¨±íµÄ£¡ºÇºÇ£¡
·þÎñÆ÷Ãû¾ÍÊÇÄãµÄÊý¾Ý¿âÃû¡£
Èç¹ûÄã×Ô¼ºÃ»½¨¹ýµÄ»°£¬¿ÉÄÜÔÚÓÃorcl°É
ÏȼþʵÀý£¬ÔÙ½¨Óû§£¬ÔÙ½¨±í¿Õ¼ä£¬ÔÙ½¨±í£¬¶ÔÓÚ³õѧÕß×îºÃ²»Òª½¨ÔÚSYSÏÂ
ÏȼþʵÀý£¬ÔÙ½¨Óû§£¬ÔÙ½¨±í¿Õ¼ä£¬ÔÙ½¨±í
½¨ÊµÀýÊǺÎÒâ?ÊÇÖ¸ÔÚ°²×°oracleµÄ¸ø¶¨µÄÒ»¸öÃû³ÆÂð£¿
ʵÀýÊÇÖ¸ÔÚ°²×°oracleµÄʱºòÊäÈëµÄÄǸöÃû³ÆÂð£¿
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......