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

oracleÖÐÌí¼Ó×Ô¶¯±àºÅ

    ÔÚaccessÖÐÓÐ×Ô¶¯±àºÅµÄÊý¾ÝÀàÐÍ£¬MSSQLºÍMYSQLÒ²¶¼ÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬²åÈë¼Ç¼ʱ²»ÓòÙ×÷´Ë×ֶΣ¬»á×Ô¶¯»ñµÃÊý¾ÝÖµ£¬¶øoracleûÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬ÎÒÃÇÐèÒª½¨Á¢Ò»¸ö×Ô¶¯Ôö³¤µÄÐòÁкţ¬²åÈë¼Ç¼ʱҪ°ÑÐòÁкŵÄÏÂÒ»¸öÖµ¸³ÓÚ´Ë×ֶΣ¬¿ÉÒÔÔ¤¼ûµÄÊÇ£¬Óд˹¦ÄÜ£¬ÎÒÃÇ¿ÉÒÔ°ÑÊý¾Ý´ÓACCESS¡¢MSSQL»òMYSQLÇ¨ÒÆµ½oracleÁË£¡
    ÔÚOracleÖÐÌí¼Ó×Ô¶¯±àºÅµÄÒ»°ã·½·¨£º£¨1£©£º½ö½öʹÓÃÐòÁУ»£¨2£©£ºÊ¹ÓÃÐòÁÐ+´¥·¢Æ÷
    ÐòÁÐÊÇÒ»Êý¾Ý¿â¶ÔÏó£¬ÀûÓÃËü¿ÉÉú³ÉΨһµÄÕûÊý¡£Ò»°ãʹÓÃÐòÁÐ×Ô¶¯µØÉú³ÉÖ÷¼üÖµ¡£¶ÔÎÒÃdzÌÐòÔ±À´½²£¬¾«Á¦Ê±¼äÓÐÏÞ£¬ÎÒÃÇֻѧ×îÓÐÓõÄ֪ʶ¡£´ó¼ÒÇë¿´£º
 ½¨Á¢ÐòÁÐÃüÁî
CREATE SEQUENCE [user.]sequence_name
[increment by n]
[start with n]
[maxvalue n | nomaxvalue]
[minvalue n | nominvalue];
[NOCYCLE]¡¡ --
INCREMENT BY£º Ö¸¶¨ÐòÁкÅÖ®¼äµÄ¼ä¸ô£¬¸ÃÖµ¿ÉΪÕýµÄ»ò¸ºµÄÕûÊý£¬µ«²»¿ÉΪ0¡£ÐòÁÐΪÉýÐò¡£ºöÂÔ¸Ã×Ó¾äʱ£¬È±Ê¡ÖµÎª1¡£
START WITH£ºÖ¸¶¨Éú³ÉµÄµÚÒ»¸öÐòÁкš£ÔÚÉýÐòʱ£¬ÐòÁпɴӱÈ×îСֵ´óµÄÖµ¿ªÊ¼£¬È±Ê¡ÖµÎªÐòÁеÄ×îСֵ¡£¶ÔÓÚ½µÐò£¬ÐòÁпÉÓɱÈ×î´óֵСµÄÖµ¿ªÊ¼£¬È±Ê¡ÖµÎªÐòÁеÄ×î´óÖµ¡£
MAXVALUE£ºÖ¸¶¨ÐòÁпÉÉú³ÉµÄ×î´óÖµ¡£
NOMAXVALUE£ºÎªÉýÐòÖ¸¶¨×î´óֵΪ1027£¬Îª½µÐòÖ¸¶¨×î´óֵΪ-1¡£
MINVALUE£ºÖ¸¶¨ÐòÁеÄ×îСֵ¡£
NOMINVALUE£ºÎªÉýÐòÖ¸¶¨×îСֵΪ1¡£Îª½µÐòÖ¸¶¨×îСֵΪ-1026¡£
NOCYCLE£ºÒ»Ö±ÀÛ¼Ó£¬²»Ñ­»· 
¸ü¸ÄÐòÁÐÃüÁî
ALTERSEQUENCE [user.]sequence_name
[INCREMENT BY n]
[MAXVALUE n| NOMAXVALUE ]
[MINVALUE n | NOMINVALUE]£» 
ÐÞ¸ÄÐòÁпÉÒÔ£º
    ÐÞ¸ÄδÀ´ÐòÁÐÖµµÄÔöÁ¿¡£
    ÉèÖûò³·Ïû×îСֵ»ò×î´óÖµ¡£
    ¸Ä±ä»º³åÐòÁеÄÊýÄ¿¡£
    Ö¸¶¨ÐòÁкÅÊÇ·ñÊÇÓÐÐò¡£
×¢Ò⣺
1£¬µÚÒ»´ÎNEXTVAL·µ»ØµÄÊdzõʼֵ
2£¬¿ÉÒÔalter³ýstartÖÁÒÔÍâµÄËùÓÐsequence²ÎÊý.Èç¹ûÏëÒª¸Ä±ästartÖµ£¬±ØÐë drop sequence ÔÙ re-create .
ɾ³ýÐòÁÐÃüÁî
/****ÓÃÓÚ´ÓÊý¾Ý¿âÖÐɾ³ýÒ»ÐòÁÐ****/
DROP SEQUENCE [user.]sequence_name£» 
SQLÖÐÈ¡ÐòÁкŵÄÓ÷¨£º
SELECT NCME_QUESTION_SEQ.nextval from dual
SELECT NCME_QUESTION_SEQ.CURRVAL from dual 
 ×¢Ò⣺ÔÚʹÓÃÐòÁеÄʱºò£¬ÓÐʱÐèÒªÓÐÓû§Ãû£¬¾ÍÏñÕâÑù£º
insert into system.CONSERVATOR(CONSERVATO


Ïà¹ØÎĵµ£º

Oracle TO_DATE,to_char

OracleÖÐTO_DATE¸ñʽ
url:http://www.cnblogs.com/ajian/archive/2009/03/25/1421063.html
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½ ......

WIN7ÏÂÔõÑù×°Oracle 10g

      
WIN7µÄϵͳ½çÃæºÜƯÁÁ£¬Ê¹ÓÃÆðÀ´È·ÊµºÜ²»´í£¬¿ÉÊÇÈ´Ò²¸øÎÒµÄѧϰ´øÀ´¹ý²»ÉÙÂé·³¡£ÓÈÆäÊÇÕâ´Î×°Oracle£¬±ðÈËÓõÄÊÇXPµÄϵͳºÜÈÝÒ×¾Í×°ÉÏÁ˵ģ¬¿ÉÊÇÎÒÈ´ÔõôҲװ²»ÉÏ¡£ÎªÁËÈÃͬÑùϲ°®WIN7µÄÅóÓÑÉÙ×ßЩÍä·£¬ÏÂÃæ¾Í½éÉÜÒ»ÏÂÔÚwin7Éϰ²×°Oracle10gµÄ·½·¨°É£¬ÄÇ¿ÉÊDZ¾ÈËÓÃÁË8Ììʱ¼ä£¬²»Í ......

oracleЭÒéÊÊÅäÆ÷´íÎóÊÇʲôԭÒò×ܽá

Ôì³ÉORA-12560: TNS: ЭÒéÊÊÅäÆ÷´íÎóµÄÎÊÌâµÄÔ­ÒòÓÐÈý¸ö£º
1.¼àÌý·þÎñûÓÐÆðÆðÀ´¡£windowsƽ̨¸öÒ»ÈçϲÙ×÷£º¿ªÊ¼---³ÌÐò---¹ÜÀí¹¤¾ß---·þÎñ£¬´ò¿ª·þÎñÃæ°å,Æô¶¯oraclehome92TNSlistener·þÎñ¡£
2.database instanceûÓÐÆðÆðÀ´¡£windowsƽ̨ÈçϲÙ×÷£º¿ªÊ¼---³ÌÐò---¹ÜÀí¹¤¾ß---·þÎñ£¬´ò¿ª·þÎñÃæ°å£¬Æô¶¯oracleserviceXXXX ......

Oracle IOÎÊÌâ½âÎö

Oracle IOÎÊÌâ½âÎö
Êý¾Ý¿âµÄ×÷ÓþÍÊÇʵÏÖ¶ÔÊý¾ÝµÄ¹ÜÀíºÍ²éѯ¡£ÈκÎÒ»¸öÊý¾Ý¿âϵͳ£¬±ØÈ»´æÔÚ¶ÔÊý¾ÝµÄ´óÁ¿¶Á»òÕßд»òÕßÁ½ÖвÙ×÷¶¼´óÁ¿´æÔÚ¡£IOÎÊÌâÒ²ÍùÍùÊǵ¼ÖÂÊý¾Ý¿âÐÔÄÜÎÊÌâµÄÖØÒªÔ­Òò¡£ÔÚÕâÆªÎÄÕÂÖУ¬Ö÷Òª°ïÖú´ó¼ÒÔÚÀí½âOracleµÄ¶Áд²Ù×÷»úÖÆµÄ»ù´¡ÉÏ£¬Áé»î½â¾öÓöµ½µÄ¸÷ÖÖ³£¼ûµÄIOÎÊÌâ¡£
1 OracleÖÐIOµÄ²úÉú
IOµ±È»°üÀ ......

ORACLEÀ䱸·Ý¼°»Ö¸´

±¸·Ý
Ö±½Ó¿½±´oracleĿ¼ÏµÄadmin¡¢oradata(datafile£¬ controlfile£¬redo)¡¢flash_recovery_areaÈý¸öÎļþ¼Ð£¬db_1Ŀ¼ÏÂdatabase(PWDfile¡¢pfile)¡¢dbs(spfile)¡¢NETWORK\ADMIN(listener.ora¡¢tnsnames.ora)£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨£¨Ð轨¿â£©
1.´´½¨Ò»¸öºÍÔ­À´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ