oracleµÄ·ÑÓÃÎÊÌâ
Ê×ÏÈ˵˵±¾ÈËÏë·¨
±¾ÈËÏëÒÔһֱѧϰoracleÊý¾Ý¿â²¢ÇÒÂýÂýµÄÉîÈëÏÂÈ¥,ËùÒÔ¾ÍÉæ¼°µ½Ê¹ÓõÄÎÊÌâµÄ,ÒòΪʹÓõĻú»áÔ½¶àËùÒÔѧÆðÀ´Ó¦¸ÃÔ½¿ì.
ËùÒÔÎÒÏëÒÔºóÔÚÏîÄ¿Öж¼Ê¹ÓÃ,ÄÇô¾Í»áÉæ¼°µ½ÊÕ·ÑÎÊÌâ,
±ÈÈç˵ÎÒÃǹ«Ë¾´î½¨Ò»¸öOAϵͳ,ҪʹÓÃoracleÊý¾Ý¿âµÄ»°.ÊDz»ÊǾÍÒª»¨Ç®Âò?
ÎÊÌâÒ»:oracleÊý¾Ý¿âÊǰ´Ê²Ã´ÔÔòÊշѵÄ?
ÊDz»ÊÇ¿ÉÒÔÃâ·ÑʹÓÃ.Èç¹ûÐèÒªoracle¹«Ë¾×öά»¤»òÏà¹Ø´¦Àí»ò·þÎñµÄÇé¿öϲÅÊÕ·Ñ.
»¹ÊÇÄãÖ»ÒªÉÌҵʹÓÃËû¾ÍÒªÊÕ·Ñ?
ÎÊÌâ¶þ:Êý¾Ý¿âÑ¡ÔñÎÊÌâ
mysqlÊÇСÐÍÊý¾Ý¿â,oracleÊÇ´óÐÍÊý¾Ý¿â(»¹ÓÐÆäËûºÜ¶à¾Í²»ÁоÙÁË,±Ï¾¹¾«Í¨Ò»Ñù²ÅÐÐ)
ÄÇôÎÒ¸ÃÈçºÎÅжÏÎÒµÄÏîÄ¿ÊÇÐèҪСÐÍÊý¾Ý¿â»¹ÊÇ´óÐ͵Ä?
±¾ÈËÉèÏë:²»¹Ü´óÐÍ»òСÐͶ¼Ê¹ÓÃoracleÕâÑùѧϰµÄ»ú»á¾Í»á¸ü¶à.µ«ÊÇÓÖµ£ÐÄÊշѵÄÎÊÌâ.
±Ï¾¹ÓÐЩÆóÒµÀϰå»á×Ô˽µÄÒ»µã.ËûÃÇÍùÍù»áÒªÇó¸ü¶àÃâ·ÑµÄ¶«Î÷.Éá²»µÃÌÍÇ®.
¾ÍºÃ±ÈÎÒÏÖÔÚÕâ¸ö¹«Ë¾.ʲô¶«Î÷¶¼ÊǵÁ°æµÄ.¸úÀϰåÌá×°¸öÕý°æµÄɱ¶¾Èí¼þ,Ëû¶¼¸úÄã¼±.
Èç¹û¸÷Î»ÍøÓÑÓпÕ.Âé·³ÔÚÊý¾Ý¿âÕâ·½ÃæµÄһЩÊг¡ÖªÊ¶¶à˵Á½¾ä,¸Ðл¸Ðл!
ORACLE ¿Í·þ.....
OracleºÍMySQL¶¼ÊÇÃâ·ÑµÄ£¬²»¹ýÌý˵ÏëÒªOracle¶îÍâµÄ·þÎñ£¬¾ÍÒªÊÕ·Ñ¡£
ORACLEÃâ·Ñ£¿ÄDz»ÖªµÀORACLEÄÄÀ´µÄÇ®ÊÕ¹ºSUNµÄ
oracleºÃÏñʹÓÃÊÇÃâ·ÑµÄ£¬Ö»ÓÐËûµÄÒ»Ð©ÌØÊâµÄ·þÎñ»áÊÕ·Ñ
ORACLEÓÐÕë¶Ô¸öÈËѧϰµÄÃâ·Ñ°æ£¬Õýʽ°æ±¾¶¼ÒªÊÕÇ®µÄ£¬·þÎñ»¹ÒªÁíÍâÊÕ
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
Oracle µÄ Ô¼ÊøÊÇÊÇ·ñ¿ÉÒÔ¸´Óã¿£¨µ÷ÓÃÔ¼ÊøÃû³Æ¾Í¿ÉÒÔÖ±½ÓʹÓøÃÔ¼Êø£©ÔÚÄÄÀï¿ÉÒÔ¹ÜÀíÔ¼Êø¡£
plsqlÓÐÕâ¸ö¹¦ÄÜô£¿
SQL code:
Ö±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraints
ÒýÓÃ
SQL ......
ΪʲôÔÚwindows7ÉÏ×°²»ÉÏoracleÊý¾Ý¿â£¿£¿£¿
ÒòΪ²»Ö§³Ö
¿ÉÒÔ°²×°Êý¾Ý°¡£¬ ÄãÓõÄÄǸö°æ±¾µÄWindows 7°¡£¬Ä¿Ç°7600µÄ¼æÈÝÐÔÓкܴóÌáÉýÁË£¬£¬ÎÒÊÇÓÃSQL Sever 2005£¬¾ÍûÓÐÎÊÌ⣬oracleÓ¦¸ÃÒ²¿ÉÒԵģ¬Èç¹û²» ......
¸ßÊÖ¸ø¸ö´æ´¢¹ý³Ì£¬ÄÜÑ»·²åÈë10ÍòÌõ¼Ç¼£»ÔÚÏߵȡ£¡£¡£
Ñ»·²åÈë10ÍòÌõ¼Ç¼£¿ÄܾßÌåµãÂð
ûÃ÷°×
SQL code:
--Á½±íÈç¹ûÒ»ÖÂʱ£º
insert into tableA as select * from tableB;
ÕâÎÊÌâÎʵÄ
ÎÞÃûÀÏ× ......