Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÀïÃæдµÄÒ»¸ö×ÔÔöº¯Êý¡£¡£¡£


Ïà¹ØÎĵµ£º

ORACLE°²×°²ÎÊý˵Ã÷¼°×¢ÒâÊÂÏ

Ô­ÎĵØÖ·£ºhttp://blog.csdn.net/fengyun14/archive/2007/03/25/1540433.aspx
¹ØÓÚLinux ÏÂkernel.shmmax µÄÉèÖÃÎÊÌâ
ÏÂÃæÊÇOracle ÎĵµÉϵĽâÊÍ£¬ http://download-west.oracle.com/doc...e.htm#sthref107
SHMMAX Available physical memory Defines the maximum allowable size of one shared memory segment.
The ......

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

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

ºìÆìDC Server 5.0ÉÏ°²×°Oracle 10g R2

  Ç°ÃæдÁ˶à·ÝºìÆìDC 4.1ºÍ5.0ÉÏ°²×°Oracle 9i/10gµÄÎĵµ£¬µ«Ò»Ö±Ã»ÓÐÕûÀíDC 5.0ÉÏ°²×°Oracle 10gµ¥»ú·þÎñÆ÷µÄ×ÊÁÏ£¬Ô­ÒòÊǸùý³Ì·Ç³£¼òµ¥¡£µ«×î½üÏîÄ¿ÖУ¬»¹ÊÇÓÐÓû§Óöµ½Ð©ÎÊÌ⣬½ñÌì¾Í°ÑһЩÐèҪעÒâµÄµØ·½ÕûÀíһϣ¬ÏêϸµÄ¹ý³Ì¾Í²»ÃèÊöÁË¡£
Ò»¡¢ÏµÍ³»·¾³
²Ù×÷ϵͳ£ººìÆì DC 5.0 for x86 »ò x86_64
Ó²¼þ»·¾ ......

ORACLE to_char() º¯Êý»ñÈ¡×ÔÈ»ÖÜÊý

 
×î¼òµ¥µÄÊÇʹÓÃ
 
/* Formatted on 2009/12/02 16:01 (Formatter Plus v4.8.8) */
SELECT TO_CHAR (TO_DATE ('2009-12-02', 'YYYY-MM-DD'), 'WW')
  from DUAL;
²»¹ýto_char()º¯ÊýÔÚ¼ÆËãÒ»ÄêÖеڼ¸ÖÜÊÇ´Ó¸ÃÄêµÄ1ÔÂ1ÈÕ¿ªÊ¼µÄ¡£
 
 ÒÔÏÂSQL Äܵõ½ÕýÈ·µÄ×ÔÈ»ÖÜÊý.
 
/* Formatted ......

OracleÖÐTO_DATE¸ñʽ

http://www.cnblogs.com/ajian/archive/2009/08/25/1421063.html
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê   &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ