´ó¼ÒÍÆ¼öÒ»¸öoracleÊý¾Ý¿âÊÓÆµ½Ì³Ì
ÎÒÏÖÔÚÓõÄÊÇSQL ServerÊý¾Ý¿â£¬Ã»ÓÐoracleÊý¾Ý¿â»ù´¡£¬´ó¼Ò¸øÎÒÍÆ¼öÒ»¸öoracleÊý¾Ý¿âÊÓÆµ½Ì³Ì£¬ºÃµÄÊé±¾½Ì²ÄÒ²ÍÆ¼öÒ»ÏÂ
ÈëÃŵÄÖ¸ÄÏÎÒÖ»¿´¹ýÒ»±¾
¾õµÃͦºÃ
oracle database 11g sql¿ª·¢Ö¸ÄÏ jason priceÖø
ʵ¼ùÊÇ×îºÃµÄÀÏʦ
ÓÐÒ»±¾¹È³¤Óµġ¶ORACLE 11gȨÍþÖ¸ÄÏ¡·¿ÉÒÔ¿´¿´£¬µ«ÊÇÀïÃæ»¹ÊÇÓÐЩÎÊÌ⣬
http://www.wangchao.net.cn/shop/product_627866.html
ͬϵÁеϹÓÐÒ»±¾ÕÔÕñƽµÄ¡¶ORACLEÊý¾Ý¿â¾«½²ÓëÒÉÄѽâÎö¡·
Õâ±¾Òª²»´íһЩµÄ
http://www.amazon.cn/ORACLE%E6%95%B0%E6%8D%AE%E5%BA%93%E7%B2%BE%E8%AE%B2%E4%B8%8E%E7%96%91%E9%9A%BE%E8%A7%A3%E6%9E%90-%E8%B5%B5%E6%8C%AF%E5%B9%B3/dp/B001AOC3B4
¿´ÉÐѧÌõÄoracleÊÓÆµ½Ì³Ì£¬ÍøÉÏÓеÄÏ¡£
·····~~~~~~~~~~~~~~~~~
ÎÒ¾ÍÊÇ¿´Õâ¸öÆð²½µÄ£¬ºÜ²»´íŶ £¡£¡£¡£¡£¡£¡£¡£¡£¡
ÂíÊ¿±øµÄºÃÏñÊÇ£¡£¡
Ö§³ÖÏÂ~~~~~~~~~~~~~~~~
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......