ORACLE»¹Ô¶ÎµÄÀàÐÍ
ϵͳ»¹Ô¶Î
½öΪϵͳ±í¿Õ¼äÖеĶÔÏó±ä»¯ËùÓá£ËüÊÇÔÚÊý¾Ý¿â´´½¨Ê±ÔÚϵͳ±í¿Õ¼äÖд´½¨µÄ¡£ÏµÍ³»¹Ô¶Î¼È¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚ×Ô¶¯Ä£Ê½Ï£¬Ò²¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚÊÖ¶¯Ä£Ê½Ï¡£
·Çϵͳ»¹Ô¶Î
ΪÆäËû±í¿Õ¼äÖжÔÏóµÄ±ä»¯ËùʹÓᣵ±Ò»¸öÊý¾Ý¿â¾ßÓжà¸ö±í¿Õ¼äʱ¾ÍÐèÒªÖÁÉÙÒ»¸öÊÖ¶¯µÄ·Çϵͳ»¹Ô¶Î»òÒ»¸ö×Ô¶¯¹ÜÀíµÄ»¹Ô±í¿Õ¼ä¡£
×Ô¶¯Ä£Ê½£ºÐèÒªÒ»¸ö»¹Ô±í¿Õ¼ä£¬ORACLE·þÎñÆ÷½«×Ô¶¯Î¬»¤»¹Ô±í¿Õ¼äÖеĻ¹ÔÊý¾Ý¡£
ÊÖ¶¯Ä£Ê½£ºÊý¾Ý¿â¹ÜÀíÔ±¸ºÔð´´½¨·Çϵͳ»¹Ô¶Î£¬ËùÓзÇϵͳ±í¿Õ¼äÖеĶÔÏóµÄ±ä»¯¶¼½«Ê¹ÓÃÕâÑùµÄ·Çϵͳ»¹Ô¶Î¡£ÔÚORACLEϵͳÖаüÀ¨ÁËÈçÏÂÁ½Àà·Çϵͳ»¹Ô¶Î£º
˽Óл¹Ô¶Î£ºÎªÒ»¸öʵÀýËùÓá£
¹«Óл¹Ô¶Î£ºÎªÈκÎÒ»¸öʵÀýËùÓá£ËüÃÇͨ³£ÊÇÔÚORACLE RACÖÐʹÓá£
ÑÓ³Ù»¹Ô¶Î
µ±Ò»¸ö±í¿Õ¼ä±»ÉèÖÃΪÍÑ»úʱ£¬Èç¹ûÐèÒª£¬ÓÉORACLEϵͳ×Ô¶¯´´½¨¡£ÑÓ³Ù»¹Ô¶Î±»ÓÃÀ´Ôڸñí¿Õ¼äÖØÐÂÉèΪÁª»úʱ»Ø¹öÊÂÎñ¡£µ±²»ÐèÒªËüÃÇʱ£¬ÏµÍ³»á×Ô¶¯½«ËüÃÇɾ³ý¡£
Ïà¹ØÎĵµ£º
¿´À´ÓеÄÈË»¹ÊǶÔschemaµÄÕæÕýº¬Ò岻̫Àí½â£¬ÏÖÔÚÎÒÔÙ´ÎÕûÀíÁËһϣ¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
ÎÒÃÇÏÈÀ´¿´Ò»ÏÂËûÃǵĶ¨Ò壺
A schema is a collection of database objects (used by a user.).
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in ......
Oracle »ñÈ¡µ±Ç°ÈÕÆÚ¼°ÈÕÆÚ¸ñʽ
»ñȡϵͳÈÕÆÚ£º SYSDATE()
¸ñʽ»¯ÈÕÆÚ£º TO_CHAR(SYSDATE(),'YY/MM/DD HH24:MI:SS)
» ......
ÎÊÌâÒ»£ºÈç±£¼ÓÔØJDBCÇý¶¯³ÌÐò£º
¡¡¡¡Õý³£ÎÒÃǼÓÔØÇý¶¯³ÌÐòÓÐÈý¸ö;¾¶£º
¡¡¡¡1£©Class.forName(String)ÕâÏëµ±ÓÚclassLoaderÒ»¸öStringÖ¸¶¨µÄÀ࣬ÔÚ×°ÔØʱ°Ñ¸ÃÇý¶¯³ÌÐòµÄ¾²Ì¬ÄÚÈݶ¼³õʼ»¯£¬ÆäʵÕâʱÇý¶¯³ÌÐòÀàµ÷ÓÃÁËDriverManager.registerDriver(driver)·½·¨
¡¡¡¡2£©Ê¹ÓÃϵͳÊôÐÔ£ºSystem.getProperty().load(new Fil ......
Õâ¸öÎÊÌâÒÔÇ°À§ÈŹýÎÒ£¬Á½Õߺó׺Ãû¶¼ÊÇ.DBF¡£¼ÇµÃµ±Ê±ºÃÏñÈ¥ÂÛ̳ÉÏ·¢Á˸öÌû×ÓÎÊ£¬²»¹ýºÃ¼¸ÌìûÈ˽â´ð£¬ÎÞÄÎÖ®ÏÂÎҾͰÑÌû×Ó¸ø½áÁË¡£
½ñÌìÕýºÃÔÚÒ»±¾ÊéÖп´µ½Óн²Á½ÕßÇø±ðµÄ£¬ÓÖÈ¥ÍøÉÏËÑÁËËÑ£¬Ð¡×ܽáһϣ¬¼ÇÏÂÀ´¡£
±¾µØ¹ÜÀíµÄÁÙʱ±í¿Õ¼äÊÇ»ùÓÚÁÙʱÎļþµÄ£¬ÕâЩÎļþÓëÆÕͨµÄÊý¾ÝÎļþ·Ç³£ÏàËÆ£¬µ«ËüÃÇ»¹¾ßÓÐÈçÏÂÌØÐÔ£º
ÁÙʱ ......