pl sql Á¬½ÓoracleÎÊÌ⣿
³õʼ»¯Ê״βâÊÔÇëʹÓÃÓû§Ãû: scott, ¿ÚÁî: tiger
ÕýÔÚ³¢ÊÔʹÓÃÒÔÏÂÓû§ ID Á¬½Ó:scott
²âÊÔûÓгɹ¦¡£
ORA-12514: TNS: ¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ
²»ÖªµÀÔõô»ØÊ£¬Çó½Ì´óÏÀÃÇ£¡Íò·Ö¸Ð¼¤£¡
ORA-12514: TNS: ¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ
1.
²é¿´Ò»Ï¼àÌýÊÇ·ñ´ò¿ª.
lsnrctl status
Èç¹ûûÓдò¿ª lsnrctl start
2.
²é¿´oracle·þÎñÊÇ·ñ´ò¿ª
net start oracleserviceorcl
3.
tnsnames.ora ºÍ listener.ora ÅäÖÃÊÇ·ñÕýÈ·
lz ²Î¿¼ ¿´¿´
http://topic.csdn.net/u/20080410/11/7ddf3f2c-7706-4ba5-89bb-93b888c45b80.html
-
http://www.yangwen626.cn/post/3.html
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......