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

Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ


Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ
1¡¢°ÑÖ÷¼ü¶¨ÒåΪ×Ô¶¯Ôö³¤±êʶ·ûÀàÐÍ
ÔÚmysqlÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪauto_incrementÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int auto_increment primary key not null, name varchar(15));
insert into customers(name) values("name1"),("name2");
select id from customers;
ÒÔÉÏsqlÓï¾äÏÈ´´½¨ÁËcustomers±í£¬È»ºó²åÈëÁ½Ìõ¼Ç¼£¬ÔÚ²åÈëʱ½ö½öÉ趨ÁËname×ֶεÄÖµ¡£×îºó²éѯ±íÖÐid×ֶΣ¬²éѯ½á¹ûΪ£º
id
1
2
Óɴ˿ɼû£¬Ò»µ©°ÑidÉèΪauto_incrementÀàÐÍ£¬mysqlÊý¾Ý¿â»á×Ô¶¯°´µÝÔöµÄ·½Ê½ÎªÖ÷¼ü¸³Öµ¡£
ÔÚMS SQLServerÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪidentityÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int identity(1,1) primary key not null, name varchar(15));
insert into customers(name) values("name1"),("name2");
select id from customers;
²éѯ½á¹ûºÍmysqlµÄÒ»Ñù¡£Óɴ˿ɼû£¬Ò»µ©°ÑidÉèΪidentityÀàÐÍ£¬MS SQLServerÊý¾Ý¿â»á×Ô¶¯°´µÝÔöµÄ·½Ê½ÎªÖ÷¼ü¸³Öµ¡£identity°üº¬Á½¸ö²ÎÊý£¬µÚÒ»¸ö²ÎÊý±íʾÆðʼֵ£¬µÚ¶þ¸ö²ÎÊý±íʾÔöÁ¿¡£
2¡¢´ÓÐòÁÐÖлñÈ¡×Ô¶¯Ôö³¤µÄ±êʶ·û
ÔÚOracleÖУ¬¿ÉÒÔΪÿÕűíµÄÖ÷¼ü´´½¨Ò»¸öµ¥¶ÀµÄÐòÁУ¬È»ºó´ÓÕâ¸öÐòÁÐÖлñÈ¡×Ô¶¯Ôö¼ÓµÄ±êʶ·û£¬°ÑËü¸³Öµ¸øÖ÷¼ü¡£ÀýÈçÒ»ÏÂÓï¾ä´´½¨ÁËÒ»¸öÃûΪcustomer_id_seqµÄÐòÁУ¬Õâ¸öÐòÁÐµÄÆðʼֵΪ1£¬ÔöÁ¿Îª2¡£
create sequence customer_id_seq increment by 2 start with 1
Ò»µ©¶¨ÒåÁËcustomer_id_seqÐòÁУ¬¾Í¿ÉÒÔ·ÃÎÊÐòÁеÄcurvalºÍnextvalÊôÐÔ¡£
curval£º·µ»ØÐòÁеĵ±Ç°Öµ
nextval£ºÏÈÔö¼ÓÐòÁеÄÖµ£¬È»ºó·µ»ØÐòÁÐÖµ
ÒÔÏÂsqlÓï¾äÏÈ´´½¨ÁËcustomers±í£¬È»ºó²åÈëÁ½Ìõ¼Ç¼£¬ÔÚ²åÈëʱÉ趨ÁËidºÍname×ֶεÄÖµ£¬ÆäÖÐid×ֶεÄÖµÀ´×ÔÓÚcustomer_id_seqÐòÁС£×îºó²éѯcustomers±íÖеÄid×ֶΡ£
create table customers(id int primary key not null, name varchar(15));
insert into customers values(customer_id_seq.curval, "name1"),(customer_id_seq.nextval, "name2");
select id from customers;
Èç¹ûÔÚoracleÖÐÖ´ÐÐÒÔÉÏÓï¾ä£¬²éѯ½á¹ûΪ£º
id
1
3
http://blog.csdn.net/andyelvis/archive/2008/05/14/2446865.aspx


Ïà¹ØÎĵµ£º

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

»ùÓÚOCCI·ÃÎÊOracleµÄ¼Ç¼

ÎÒÔÚoracle 9iµÄ»·¾³Ï¿ª·¢ÁËocciµÄÓ¦Ó㬽á¹û·Åµ½10g(10.2.0.3)·þÎñÆ÷ÉÏÔËÐв»ÁË(Ö»×°ÁËwindows °æµÄ10g·þÎñ¶Ë)£¬Ö»ºÃ°ÑËùÓÐÒÀÀµµÄ9iµÄdll¿½¹ýÈ¥£¬½á¹ûÁ¬½Óocci±¨´í£º
Error while trying to retrieve text for error ORA-32101
µ½http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.ht ......

Java¿ª·¢OracleÊý¾Ý¿âµÄORA 01000´íÎó½âÎö

ºÜ¶àÅóÓÑÔÚJava¿ª·¢ÖУ¬Ê¹ÓÃOracleÊý¾Ý¿âµÄʱºò£¬¾­³£»áÅöµ½ÓÐORA-01000: maximum open cursors exceeded.µÄ´íÎó¡£
ʵ¼ÊÉÏ£¬Õâ¸ö´íÎóµÄÔ­Òò£¬Ö÷Òª»¹ÊÇ´úÂëÎÊÌâÒýÆðµÄ¡£
ora-01000: maximum open cursors exceeded.
±íʾÒѾ­´ïµ½Ò»¸ö½ø³Ì´ò¿ªµÄ×î´óÓαêÊý¡£
ÕâÑùµÄ´íÎóºÜÈÝÒ׳öÏÖÔÚJava´úÂëÖеÄÖ÷ÒªÔ­ÒòÊÇ£ºJava´úÂëÔÚÖ´ ......

ÈçºÎ°²×°mysql plugin


¡¡¡¡1¡¢°²×°Plugin
¡¡¡¡Óï·¨ÈçÏ£º INSTALL PLUGIN plugin_name SONAME 'plugin_library'
¡¡¡¡ÊµÀý£º
¡¡¡¡Mysql>INSTALL PLUGIN  Archive    SONAME ‘ha_archive.so’;
¡¡¡¡Mysql>INSTALL PLUGIN  InnoDB    SONAME ‘ha_innodb.so’;
¡¡
¡¡p ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ