oracle ²åÈëÊý¾ÝÎ¥·´Î¨Ò»ÐÔ
ÎÒ°ÑÎÒËùÔÚÓû§µÄ±íÈ«²¿É¾³ýÁË£¬È»ºóÖØÐµ¼È룬֮ºóÔÚÔËÐгÌÐòËùÓеIJåÈë²Ù×÷¶¼±¨Î¥·´Î¨Ò»ÐÔÔ¼Êø£¬ÕâÊÇΪʲô£¿
±íÐòÁÐô,»¹ÊÇË÷Òý,»¹ÊÇÖ÷¼üÎ¥·´Î¨Ò»ÐÔÔ¼Êø
ORA-00001 Ó¦¸ÃÊÇÖ÷¼ü°É
¿ÉÄÜÊÇË÷Òý°É£¬°ÑË÷ÒýҲɾÁË
ÎÊÌâ½â¾öÁË ÊÇsequencesÖØÐµ¼ÈëµÄʱºòûÓиüÐÂ
¤Î ѧϰÁË
ÔÎ
ºÇºÇ£¡Ï´Î×¢Òâµã£¡
ÎÊÌâ½â¾öÁË£¬¾ÍÀ´½Ó·Ö£¬ºÇºÇ!
ÓпÉÄÜÊÇÊý¾ÝÓÐÖØ¸´£¬Ôì³ÉÎ¥·µµÄÔ¼Êø
¶î ÈÃÈËÀË·ÑÄÔϸ°ûÁË... LZÕæ»µ
ÎÊÌâ½â¾öÁË ÊÇsequencesÖØÐµ¼ÈëµÄʱºòûÓиüÐÂ
Ï´Î×¢ÒâÀ² Õâʱºò»ù±¾µÄ
okokokoko
¶à×¢Òâ¹þ.
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
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¡¡£±£±£Ç
¾ßÌåµãлл£¬×îºÃÄܾٸöÀý×Ó£¬ÍøÉϵͼÊÇ£¸iµÄ²Ù×÷²½Ö裬²»ÔõôºÃÓÃ
ÒýÓÃ
Ôõô°Ñһ̨µçÄÔÖеıí¿Õ¼äÒÆ¶¯µ½Áíһ̨ÖÐÓã¿
ORACLE¡¡£±£±£Ç
¾ßÌåµãлР......