ÔÚoracle±íÖÐÔõÑù´´½¨×ÔÔö³¤×Ö¶Î
.½¨Á¢²âÊÔÊý¾Ý±í
CREATE TABLE TEST
(
ID NUMBER PRIMARY KEY,
NAME VARCHAR2(20)
);
2.´´½¨ÐòÁÐ
CREATE SEQUENCE SEQ_TEST;
3.´´½¨´¥·¢Æ÷
CREATE OR REPLACE TRIGGER AUTOINCREMENT
BEFORE INSERT ON TEST
FOR EACH ROW
WHEN (NEW.ID IS NULL)
BEGIN
SELECT SEQ_TEST.NEXTVAL INTO :NEW.ID from DUAL;
END;
/
4.²åÈëÊý¾Ý
INSERT INTO TEST(NAME) VALUES('increase');
5.²é¿´²åÈë½á¹û
SELECT * from TEST;
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1 ·ÖÇø±íPARTITION table
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1.1 ·ÖÇø±íµÄ½¨Á¢£º
ij¹«Ë¾µÄÿÄê²úÉú¾Þ´óµÄÏúÊۼǼ£¬DBAÏò¹«Ë¾½¨Òéÿ¼¾¶ÈµÄÊý¾Ý·ÅÔÚÒ»¸ö·ÖÇøÄÚ£¬ÒÔÏÂʾ·¶µÄÊǸù«Ë¾1999ÄêµÄÊý¾Ý( ......
ÔÚµ¼ÍêÊý¾ÝÖ®ºó·¢ÏÖ oracleµÄ°²×°ÅÌÖ»Óм¸MµÄ¿Õ¼äÁË¡£
ÏÖÔÚÓÐÁ½¸ö·½°¸¿ÉÒÔÑ¡Ôñ
1.°ÑÊý¾ÝÎļþ×ªÒÆµ½ÁíÍâÒ»¸öÅÌÈ¥¡£
ÎÒµ¼Êý¾ÝµÄʱºòÊÇÕâÑù×öµÄ 1.н¨Ò»¸ö±í¿Õ¼ä£¬Îª±í¿Õ¼äÌí¼ÓÒ»¸öÊý¾ÝÎļþ£¨assure_dt£©¡£2.н¨Óû§£¬±í¿Õ¼äÖ¸Ïò²½Öè1н¨µÄ±í¿Õ¼ä¡£
È»ºóµ¼Èë¡£ÎÒÓõÄÊÇoracle 10g
ÎÊÌâ1.ΪʲôÎÒÌí¼ÓµÄÊý¾ÝÎļþas ......
²»ÄÜÁ¬½ÓOracleÊý¾Ý¿âÁË,ÌáʾÏà¹ØµÄ´íÎó
OERR: ORA-12519 TNS:no appropriate service handler found
¿Í»§¶ËÁ¬½Ó¼äЪÐÔʧ°Ü£¬±¨´íORA-12519
Cause: the listener could not find any available service handlers that are
appropriate fo ......