Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLE»¹Ô­¶ÎµÄÀàÐÍ

ϵͳ»¹Ô­¶Î
½öΪϵͳ±í¿Õ¼äÖеĶÔÏó±ä»¯ËùÓá£ËüÊÇÔÚÊý¾Ý¿â´´½¨Ê±ÔÚϵͳ±í¿Õ¼äÖд´½¨µÄ¡£ÏµÍ³»¹Ô­¶Î¼È¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚ×Ô¶¯Ä£Ê½Ï£¬Ò²¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚÊÖ¶¯Ä£Ê½Ï¡£
·Çϵͳ»¹Ô­¶Î
ΪÆäËû±í¿Õ¼äÖжÔÏóµÄ±ä»¯ËùʹÓᣵ±Ò»¸öÊý¾Ý¿â¾ßÓжà¸ö±í¿Õ¼äʱ¾ÍÐèÒªÖÁÉÙÒ»¸öÊÖ¶¯µÄ·Çϵͳ»¹Ô­¶Î»òÒ»¸ö×Ô¶¯¹ÜÀíµÄ»¹Ô­±í¿Õ¼ä¡£
×Ô¶¯Ä£Ê½£ºÐèÒªÒ»¸ö»¹Ô­±í¿Õ¼ä£¬ORACLE·þÎñÆ÷½«×Ô¶¯Î¬»¤»¹Ô­±í¿Õ¼äÖеĻ¹Ô­Êý¾Ý¡£
ÊÖ¶¯Ä£Ê½£ºÊý¾Ý¿â¹ÜÀíÔ±¸ºÔð´´½¨·Çϵͳ»¹Ô­¶Î£¬ËùÓзÇϵͳ±í¿Õ¼äÖеĶÔÏóµÄ±ä»¯¶¼½«Ê¹ÓÃÕâÑùµÄ·Çϵͳ»¹Ô­¶Î¡£ÔÚORACLEϵͳÖаüÀ¨ÁËÈçÏÂÁ½Àà·Çϵͳ»¹Ô­¶Î£º
˽Óл¹Ô­¶Î£ºÎªÒ»¸öʵÀýËùÓá£
¹«Óл¹Ô­¶Î£ºÎªÈκÎÒ»¸öʵÀýËùÓá£ËüÃÇͨ³£ÊÇÔÚORACLE RACÖÐʹÓá£
ÑÓ³Ù»¹Ô­¶Î
µ±Ò»¸ö±í¿Õ¼ä±»ÉèÖÃΪÍÑ»úʱ£¬Èç¹ûÐèÒª£¬ÓÉORACLEϵͳ×Ô¶¯´´½¨¡£ÑÓ³Ù»¹Ô­¶Î±»ÓÃÀ´Ôڸñí¿Õ¼äÖØÐÂÉèΪÁª»úʱ»Ø¹öÊÂÎñ¡£µ±²»ÐèÒªËüÃÇʱ£¬ÏµÍ³»á×Ô¶¯½«ËüÃÇɾ³ý¡£


Ïà¹ØÎĵµ£º

ORACLE Schema µÄÀí½â

¿´À´ÓеÄÈË»¹ÊǶÔ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 »ñÈ¡µ±Ç°ÈÕÆÚ¼°ÈÕÆÚ¸ñʽ

Oracle »ñÈ¡µ±Ç°ÈÕÆÚ¼°ÈÕÆÚ¸ñʽ
   »ñȡϵͳÈÕÆÚ£º  SYSDATE()
   ¸ñʽ»¯ÈÕÆÚ£º     TO_CHAR(SYSDATE(),'YY/MM/DD HH24:MI:SS)
                      » ......

Java+OracleÓ¦Óÿª·¢µÄ¼¸¸öÎÊÌâ


ÎÊÌâÒ»£ºÈç±£¼ÓÔØJDBCÇý¶¯³ÌÐò£º
¡¡¡¡Õý³£ÎÒÃǼÓÔØÇý¶¯³ÌÐòÓÐÈý¸ö;¾¶£º
¡¡¡¡1£©Class.forName(String)ÕâÏëµ±ÓÚclassLoaderÒ»¸öStringÖ¸¶¨µÄÀ࣬ÔÚ×°ÔØʱ°Ñ¸ÃÇý¶¯³ÌÐòµÄ¾²Ì¬ÄÚÈݶ¼³õʼ»¯£¬ÆäʵÕâʱÇý¶¯³ÌÐòÀàµ÷ÓÃÁËDriverManager.registerDriver(driver)·½·¨
¡¡¡¡2£©Ê¹ÓÃϵͳÊôÐÔ£ºSystem.getProperty().load(new Fil ......

ORACLEÖÐÁÙʱÎļþºÍÊý¾ÝÎļþµÄÇø±ð

Õâ¸öÎÊÌâÒÔÇ°À§ÈŹýÎÒ£¬Á½Õߺó׺Ãû¶¼ÊÇ.DBF¡£¼ÇµÃµ±Ê±ºÃÏñÈ¥ÂÛ̳ÉÏ·¢Á˸öÌû×ÓÎÊ£¬²»¹ýºÃ¼¸ÌìûÈ˽â´ð£¬ÎÞÄÎÖ®ÏÂÎҾͰÑÌû×Ó¸ø½áÁË¡£
½ñÌìÕýºÃÔÚÒ»±¾ÊéÖп´µ½Óн²Á½ÕßÇø±ðµÄ£¬ÓÖÈ¥ÍøÉÏËÑÁËËÑ£¬Ð¡×ܽáһϣ¬¼ÇÏÂÀ´¡£
±¾µØ¹ÜÀíµÄÁÙʱ±í¿Õ¼äÊÇ»ùÓÚÁÙʱÎļþµÄ£¬ÕâЩÎļþÓëÆÕͨµÄÊý¾ÝÎļþ·Ç³£ÏàËÆ£¬µ«ËüÃÇ»¹¾ßÓÐÈçÏÂÌØÐÔ£º
ÁÙʱ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ