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

hibernateÖÐoracleµÄ×ÔÔöÎÊÌ⣺

Ò»Ö±ÒÔΪ  <id name="id" type="integer">
<column name="ID" precision="5" scale="0" />
<generator class="sequence"¡¡/>
</id> ÕâÑù¾Í¿ÉÒÔ×ÔÔöÁË¡£¡£
¿É½ñÌìÔÚ²âÊÔʱ£¬·¢ÏÖ¿ØÖÆÌ¨Ò»Ö±±¨“ÐòÁкŲ»´æÔÚ"µÄ´í¡£¡£¡£ºóÀ´²ÅÖªµÀÔÚsequenceºóÃæ»¹Òª¼ÓÉÏoracleÊý¾Ý¿âÀïÃæµÄ×ÔÔöµÄÃû×Ö¡£¡£
ÒÔÏÂÊǽâ¾öµÄ·½°¸£º
<id name="id" type="integer">
<column name="ID" precision="5" scale="0" />
<generator class="sequence">
<param name="sequence">nid</param>
</generator>
</id> 
ÆäÖÐnidÊÇÎÒ×Ô¼ºÔÚoracleÀïÃæÐ´µÄÒ»¸ö×ÔÔöº¯Êý¡£¡£¡£


Ïà¹ØÎĵµ£º

hibernate¸ù¾Ýʱ¼äÈÕÆÚÀ´²éѯoracleÊý¾Ý¿â

ʹÓÃÄ£ºý²éѯ£º
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd"); 
Date startdate = sdf.parse(start_date);
Date enddate = sdf.parse(end_date);
List list = sess.createCriteria(MyTabel.class)
               .add( ......

ORACLE RAC¹¤×÷Ô­Àí


ORACLE RAC¹¤×÷Ô­Àí
ORACLE RAC¹¤×÷Ô­Àí
¡¡¡¡ÔÚÒ»¸öÓ¦Óû·¾³µ±ÖУ¬ËùÓеķþÎñÆ÷ʹÓú͹ÜÀíͬһ¸öÊý¾Ý¿â£¬Ä¿µÄÊÇΪÁË·Öɢÿһ̨·þÎñÆ÷µÄ¹¤×÷Á¿£¬Ó²¼þÉÏÖÁÉÙÐèÒªÁ½Ì¨ÒÔÉϵķþÎñÆ÷£¬¶øÇÒ»¹ÐèÒªÒ»¸ö¹²Ïí´æ´¢É豸¡£Í¬Ê±»¹ÐèÒªÁ½ÀàÈí¼þ£¬Ò»¸öÊǼ¯ÈºÈí¼þ£¬ÁíÍâÒ»¸ö¾ÍÊÇOracleÊý¾Ý¿âÖеÄRAC×é¼þ¡£Í¬Ê±ËùÓзþÎñÆ÷ÉϵÄOS¶¼Ó¦¸ÃÊÇÍ ......

OracleÖÐΪʲôwhere rownum > 3 ²éÕÒ²»µ½Êý¾Ý£¿

²éѯ±íempÖÐËùÓÐÊý¾Ý
select emp_id,rownum from emp
µÚÒ»²½£¬²éѯ½á¹û,rownum´ý¶¨
emp_id rownum
1         ?   1
2         ?   2
3         ?   3
4&n ......

Oracle±¸·Ý½Å±¾


Ä¿±ê£ºÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£¬Ö»Òª»á¼òµ¥µÄlinuxÃüÁî¾ÍÄÜʵÏÖoracle expµÄ×Ô¶¯±¸·Ý
 
»·¾³£ºlinux as3+oracle9i
¾ßÌåµÄ²½Ö裺
 
1.ÓʼþÉèÖÃ
[root@sxapp1 mail]# cd /etc/mail
[root@sxapp1 mail]# mv submit.cf submit.cfbak
[root@sxapp1 spool]# chmod a+wrx mqueue/
[root@sxapp1 mail]# echo "sdsd ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ