¡¶Í¿Ä¨Oracle£Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle¡·³ö¯ÊÖ¼Ç
¡öÀÖÖª
“ËÊÇ˵ÄË”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Ê顶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ»¾ä¸è´Ê£ºÄã¿´´°Í⻨¿ªÄÇôÃÀ¡£
ÎÒϲ»¶»¨¿ª¡£³É¾ÍÒ»¶ä»¨¿ª£¬²¥ÖÖ¡¢½½Ë®¡¢Ê©·Ê¡¢´òÀí£¬ËäÈ»ÓÐȤ£¬ÀÛÈ´ÊÇÃâ²»Á˵ġ£Èç¹ûÏ뻨¿ª»¨ÔÙ¿ª£¬ÄǾ͸üÀÛÁË¡£
²»¹ýÕâÖÖÀÛ£¬ÓëÔÚѧϰOracleµÄ½¹ÓÍ¿ÓÖÐÉíÐľãÆ£µÄÃâ×ÓÃǵÄÀÛÏà±È£¬ÏÔÈ»²»ÖµÒ»Ìá¡£Ó£ÌҺóÔÊ÷ÄÑÔÔÕâ¾ä»°£¬¾ÍÊÇÏÈÈËΪ¹æÈ°ºóÈËǧÍò²»ÒªÑ§Ï°Oracle¶ø×¼±¸µÄ¡£OracleÃλõÄְҵǰ¾°Èü¼ÊõÈËÇ÷Ö®ÈôðÍ£¬ÆäÅÓ´óÓ븴ÔÓÈ´ÓÖÍùÍùÈÃÈË°ë;¶ø·Ï¡£×÷Ϊ¼¼ÊõÀàͼÊéµÄ²ß»®±à¼£¬ÎÒʱʱÔÚÏ룬ʲôÑùµÄOracleͼÊéÄܹ»½â¾öÈÃÈË°ë;¶ø·ÏµÄÎÊÌâÄØ£¿ÈëÃÅ¡¢°¸Àý¡¢ÊµÕ½£¿¾«Í¨¡¢¾«½â¡¢¾«½²£¿¸ß¿ÉÓᢸßÐÔÄÜ¡¢¸ß°²È«£¿Ò»¸ö¸öµãÃæ²»ÇåµÄ˼·ÔÚ»ìÂÒÖгåײ£¬ÔÚ³åײÖлìÂÒ¡£
ijÄêijÔÂijһÌì¡£
ITPUBÏй䣬¿´Ä³²©ÎÄÖÐÓÐÒ»¾ä³ö×Ô¿××ӵĻ°£ºÖªÖ®Õß²»ÈçºÃÖ®Õߣ¬ºÃÖ®Õß²»ÈçÀÖÖ®Õß¡£Õâ¶úÊìÄÜÏêµÄÒ»¾ä»°£¬È´Áî¶àÈյĻìÂÒÓë³åײͻȻͣϢ¡£¿´À´Ê¥ÈËÕæ²»ÊÇ°×µ±µÄ£¬Ò»Ï¾ÍÄÜ¿´µ½ÎÊÌâµÄ±¾ÖÊ¡£ÀÖÖª£¬¾ÍÊÇ°Ñѧϰ±ä³É°®ºÃ£¬±ä³ÉÐËȤ£¬±ä³ÉÏíÊÜ¡£ÈË£¬Ê²Ã´¶¼ºÃ·ÅÆú£¬Î¨¶À²»ºÃ·ÅÆúµÄ¾ÍÊÇÏíÊÜ£¬ËùÒÔÈç¹ûÄÜ°ÑOracle¸É²ÝÒ»°ãµÄ¿ÝÔïת±ä³É÷Ò÷Ñ´ó²ÍµÄÏíÊÜ£¬²»¾ÍÊÇÕÒµ½ÁËÄÇÕµ¹¥¿ËOracleµÄ°¢À¶¡ÉñµÆÂð£¿
¡öɨµØÉ®
Oracle£¬ÕõÇ®ÈÝÒ×ѧÆðÀ´ÄÑ£¬ÕýÈç°¢À¶¡ÉñµÆ£¬ÓÃÆðÀ´ÈÝÒ×Ñ°ÆðÀ´ÄÑ¡£ÎÞÊý¸öÈÕÒ¹µÄÑ°ÃÙ£¬×ܲ»¼ûÉñµÆµÄÉíÓ°¡£
ÓÖÊÇijÄêijÔÂijһÌì¡£
Îҵ㿪ÁËһƪ²©¿Í£¬Ó³ÈëÑÛÁ±µÄÊÇÒ»ÐÐÇ©Ãû£º
ɨµØ²»¹ýÊÇÎÒ±íÃæÉϵŤ×÷£¬ÎÒÕæÕýµÄÉí·ÝÆäʵÊÇÎÞÃûÀÏÉ®——ÊÖÀïÄǸùɨ°Ñ~
Õâ¾ÍÊǾýÈý˼£¨¹úÄÚÊý¾Ý¿âÁìÓò×î¾ßÓ°ÏìÁ¦µÄÍøÕ¾Ö®Êý¾Ý¿â°æ°æÖ÷Àî±ûÑóµÄÍøÃû£©µÄ²©¿Í¡£Ëæ±ãµã¿ªÁËһƪÃûΪ¡¶Ð¡¼Çpub08Äê»áÈýÁ½ÊÂÖ®Èý¡¢´òÆË¿Ë~~~¡·£¨Á´½Ó¼ûhttp://space.itpub.net/7607759/viewspace-151194£©µÄ²©ÎÄ¡£¶ÁÍêºó£¬Ëäδ¼ûÆäÈË£¬µ«Ò»¸öÈ÷ÍÑ¡¢»úÖÇ¡¢ÓÄĬ¡¢²Å»ªºáÒç»òÐí»¹ÓÐЩ»µµÄ¾ýÈý˼ÒѾ»îÍÑÍѸ¡ÏÖÓÚÄÔº£¡£ÎÒ¿ªÊ¼ä¯À
Ïà¹ØÎĵµ£º
ÔÎĵØÖ·£ºhttp://fandayrockworld.javaeye.com/blog/540509
»Ø¹Ë£º
Ò»¡¢ ROWIDµÄ¸ÅÄî
¡¡¡¡´æ´¢ÁËrowÔÚÊý¾ÝÎļþÖеľßÌåλÖãº64λ±àÂëµÄÊý¾Ý£¬A-Z, a-z, 0-9, +, ºÍ /£¬
¡¡¡¡rowÔÚÊý¾Ý¿éÖеĴ洢·½Ê½
¡¡¡¡SELECT ROWID, last_name from hr.employees WHERE department_id = 20;
¡¡¡¡±ÈÈ磺OOOOOOFFFBBBBBBRRR
......
1.SQL> select * from v$nls_parameters;
PARAMETER VALUE
----------------------------------- ------------------------------------
---------- ......
Êý¾Ýµ¼³ö£º
1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:\daochu.dmpÖÐ
exp system/manager@TEST file=d:\daochu.dmp full=y
2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
3 ½«Êý¾Ý¿âÖеıíin ......
28.5 OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM
OracleÆóÒµ¹ÜÀíÆ÷£¨Oracle Enterprise Manager£¬OEM£©ÊÇOracleÌṩµÄÒ»¸ö»ùÓÚWebµÄͼÐλ¯Êý¾Ý¿â¹ÜÀí¹¤¾ß¡£Í¨¹ýOEM£¬Óû§¿ÉÒÔÍê³É¼¸ºõËùÓеÄÔÀ´Ö»ÄÜͨ¹ýÃüÁîÐз½Ê½Íê³ÉµÄ¹¤×÷£¬°üÀ¨Êý¾Ý¿â¶ÔÏó¡¢Óû§È¨ÏÞ¡¢Êý¾ÝÎļþ¡¢¶¨Ê±ÈÎÎñµÄ¹ÜÀí£¬Êý¾Ý¿â²ÎÊýµÄÅäÖ㬱¸·ÝÓë»Ö¸´£¬ÐÔÄÜ ......
28.6 Oracle³£¼ûÎÊÌâ´¦Àí
±¾½Ú½éÉÜÔÚRed Hat Enterprise Linux 5.2ÉÏ°²×°¼°ÅäÖÃOracleÊý¾Ý¿â·þÎñÆ÷ÖУ¬³£¼ûµÄÎÊÌâ¼°½â¾ö·½·¨£¬°üÀ¨ÈçºÎ»ñµÃÊý¾Ý¿â´´½¨¹ý³ÌÖеÄÏêϸÐÅÏ¢£¬·ÃÎÊOEM³öÏÖ“°²È«Á¬½Óʧ°Ü£¬Ê¹ÓÃÁËÎÞЧµÄ°²È«Ö¤Êé”´íÎóÒÔ¼°Íü¼ÇsysÓû§¿ÚÁîºóµÄ´¦Àí·½·¨µÈ¡£ ......