oracleÁ¬½ÓÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ
ÎÒÔÚʹÓÃSQLplusÁ¬½ÓoracleµÄʱºòÔõôÐÒéÊÊÅäÆ÷´íÎó£¿ÊDz»ÎÒÓ¦¸Ã¸ÄÏÂÎÒµÄip£¬¸Ä³ÉÎÒ°²×°Ê±ºòµÄip£¡´ó¼Ò°ïÖúÎÒһϣ¡
ÊDZ¾»úµÄ»°,¶øÇÒ±¾»úµÄIPµØÖ·ÓÖ²»ÊÇDNS»ñÈ¡µÄ,¾ÍÊDz»Ëµ±ä»¯µÄ»°¾Í¿ÉÒÔ¸ÄΪ±¾»úIP,µ«ÊÇÈç¹ûÊDZ仯µÄ,¸Ä³É±¾»úµÄϵͳÃû³Æ¼´¿É ¿´¿´ÄãµÄtnsname.oraÎļþÀïµÄ¶«Î÷¿´¿´... sqlplus username/password@tnsname.oraÎļþÀïµÄÄÚÈÝ ±¾»úIP¿ÉÒÔÖ±½ÓÐ޸ijÉlocalhost£¬ºÇºÇ¡£ ¸Ð¾õºÃÏñÊǼàÌýÆ÷µÄÎÊÌâ¡£¿´¿´ÄãlistenerÅäÖÃÊDz»ÊǶԵġ£ÒýÓà ¸Ð¾õºÃÏñÊǼàÌýÆ÷µÄÎÊÌâ¡£¿´¿´ÄãlistenerÅäÖÃÊDz»ÊǶԵġ£ Õâ¸öºÍ¼àÌý¹ØÏµ²»´ó£¬Ö»ÓÐÔ¶³ÌµÇ¼²ÅÐèÒª¼àÌý£¬»¹ÊÇ¿´Ò»ÏÂtnsnameÎļþ°É Èç¹ûÊDZ¾»úÁ¬½ÓµÄ»°£¬ÊDz»ÐèÒªÅäÖÃtnsnames.oraµÄ 1¡¢È·¶¨±¾»úÊÇ·ñ¸Ä¹ý¼ÆËã»úÃû³Æ 2¡¢ÔÚ×¢²á±íÖв鿴ÊÇ·ñÓÐÏàӦ·¾¶ 3¡¢¼ì²étnsnames.ora¡¢listener.oraÎļþ¶ÔÓ¦»úÆ÷Ãû»òipÊÇ·ñÒ»ÖÂ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷ µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿ È磺 ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ MySQLʹÓõÄÊÇselect @@tx_isolation; ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿ SQL code: SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......