oracleµÄ·ÑÓÃÎÊÌâ
Ê×ÏÈ˵˵±¾ÈËÏë·¨
±¾ÈËÏëÒÔһֱѧϰoracleÊý¾Ý¿â²¢ÇÒÂýÂýµÄÉîÈëÏÂÈ¥,ËùÒÔ¾ÍÉæ¼°µ½Ê¹ÓõÄÎÊÌâµÄ,ÒòΪʹÓõĻú»áÔ½¶àËùÒÔѧÆðÀ´Ó¦¸ÃÔ½¿ì.
ËùÒÔÎÒÏëÒÔºóÔÚÏîÄ¿Öж¼Ê¹ÓÃ,ÄÇô¾Í»áÉæ¼°µ½ÊÕ·ÑÎÊÌâ,
±ÈÈç˵ÎÒÃǹ«Ë¾´î½¨Ò»¸öOAϵͳ,ҪʹÓÃoracleÊý¾Ý¿âµÄ»°.ÊDz»ÊǾÍÒª»¨Ç®Âò?
ÎÊÌâÒ»:oracleÊý¾Ý¿âÊǰ´Ê²Ã´ÔÔòÊշѵÄ?
ÊDz»ÊÇ¿ÉÒÔÃâ·ÑʹÓÃ.Èç¹ûÐèÒªoracle¹«Ë¾×öά»¤»òÏà¹Ø´¦Àí»ò·þÎñµÄÇé¿öϲÅÊÕ·Ñ.
»¹ÊÇÄãÖ»ÒªÉÌҵʹÓÃËû¾ÍÒªÊÕ·Ñ?
ÎÊÌâ¶þ:Êý¾Ý¿âÑ¡ÔñÎÊÌâ
mysqlÊÇСÐÍÊý¾Ý¿â,oracleÊÇ´óÐÍÊý¾Ý¿â(»¹ÓÐÆäËûºÜ¶à¾Í²»ÁоÙÁË,±Ï¾¹¾«Í¨Ò»Ñù²ÅÐÐ)
ÄÇôÎÒ¸ÃÈçºÎÅжÏÎÒµÄÏîÄ¿ÊÇÐèҪСÐÍÊý¾Ý¿â»¹ÊÇ´óÐ͵Ä?
±¾ÈËÉèÏë:²»¹Ü´óÐÍ»òСÐͶ¼Ê¹ÓÃoracleÕâÑùѧϰµÄ»ú»á¾Í»á¸ü¶à.µ«ÊÇÓÖµ£ÐÄÊշѵÄÎÊÌâ.
±Ï¾¹ÓÐЩÆóÒµÀϰå»á×Ô˽µÄÒ»µã.ËûÃÇÍùÍù»áÒªÇó¸ü¶àÃâ·ÑµÄ¶«Î÷.Éá²»µÃÌÍÇ®.
¾ÍºÃ±ÈÎÒÏÖÔÚÕâ¸ö¹«Ë¾.ʲô¶«Î÷¶¼ÊǵÁ°æµÄ.¸úÀϰåÌá×°¸öÕý°æµÄɱ¶¾Èí¼þ,Ëû¶¼¸úÄã¼±.
Èç¹û¸÷Î»ÍøÓÑÓпÕ.Âé·³ÔÚÊý¾Ý¿âÕâ·½ÃæµÄһЩÊг¡ÖªÊ¶¶à˵Á½¾ä,¸Ðл¸Ðл!
ORACLE ¿Í·þ.....
OracleºÍMySQL¶¼ÊÇÃâ·ÑµÄ£¬²»¹ýÌý˵ÏëÒªOracle¶îÍâµÄ·þÎñ£¬¾ÍÒªÊÕ·Ñ¡£
ORACLEÃâ·Ñ£¿ÄDz»ÖªµÀORACLEÄÄÀ´µÄÇ®ÊÕ¹ºSUNµÄ
oracleºÃÏñʹÓÃÊÇÃâ·ÑµÄ£¬Ö»ÓÐËûµÄÒ»Ð©ÌØÊâµÄ·þÎñ»áÊÕ·Ñ
ORACLEÓÐÕë¶Ô¸öÈËѧϰµÄÃâ·Ñ°æ£¬Õýʽ°æ±¾¶¼ÒªÊÕÇ®µÄ£¬·þÎñ»¹ÒªÁíÍâÊÕ
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
Oracle µÄ Ô¼ÊøÊÇÊÇ·ñ¿ÉÒÔ¸´Óã¿£¨µ÷ÓÃÔ¼ÊøÃû³Æ¾Í¿ÉÒÔÖ±½ÓʹÓøÃÔ¼Êø£©ÔÚÄÄÀï¿ÉÒÔ¹ÜÀíÔ¼Êø¡£
plsqlÓÐÕâ¸ö¹¦ÄÜô£¿
SQL code:
Ö±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraints
ÒýÓÃ
SQL ......
·þÎñÆ÷ϵ缸Ììºó½ñÌìÉϵ磬Êý¾Ý¿âÈ´ÔõôҲÆð²»ÁËÁË£¬¾ßÌåÇé¿öÈçÏ£º
SQL> startup
ORACLE instance started.
Total System Global Area 5010685952 bytes
Fixed Size & ......