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

ÏòOracle²åÈëÊý¾ÝÔõô±¨´í°¡£¿£¨ÔôÏ벻ͨ£©

ÒÔǰûÓÐÔõôÓùýOracle£¬oralceµÄ°üÒ²µ¼ÈëÁ˰¡£¬ÕæÊÇÏ벻ͨ°¡¡£¡£¡£¡£¡£Ï£Íû´ó¼ÒÄܰïÎÒ¿´¿´°¡£¬Ð»Ð»°¡¡£¡£¡£

java´úÂ룺
package com.xiaotong.taobao.bean;

public class Teacher {

private int id;
private String teachername;

public int getId() {
return id;
}

public void setId(int id) {
this.id = id;
}

public String getTeachername() {
return teachername;
}

public void setTeachername(String teachername) {
this.teachername = teachername;
}
}


Ó³ÉäÎļþ£º***********************************************
<hibernate-mapping package="com.xiaotong.taobao.bean">
<class name="Teacher">
<id name="id">
<generator class="sequence">
<param name="sequence">Teacher_id_seq </param>
</generator>
</id>

<property name="teachername" column="teacher_name"/>
</class>
</hibernate-mapping>

²âÊÔÀà´úÂ룺***********************************
package com.xiaotong.taobao.test;

import org.hibernate.Session;
import org.hibernate.Transaction;

import com.xiaotong.taobao.bean.Teacher;
import com.xiaoton


Ïà¹ØÎÊ´ð£º

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ