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ÀïÃæÐ´µÄÒ»¸ö×ÔÔöº¯Êý¡£¡£¡£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
select t.lot_number
from inv.mtl_onhand_quantities_detail t
left join mtl_system_items_b mi
on t.inventory_item_id = mi.inventory_item_id
where mi.segment1 like '101%' and mi.organization_id = 102
group by t.lot_number having count(*)=1 union
select t.lot_number||'x'
......
֮ǰ¿´µ½Ò»ÆªÎÄÕÂ, ¾õµÃ²»´í! ¿´Á˺ó,·¢¾õ×Ô¼º»¹ÓÐºÜ¶àµØ·½ÐèÒª²¹×ã, »¹ÐèҪŬÁ¦°¡£¡ÈÎÖØ¶øµÀÔ¶£¡
DBAÐèÒªµÄ¼¼ÄÜ
dbaÕÆÎյļ¼Êõ
1. os : linux,solaris»òÆäËûunixÆðÂëÒªÒ»ÖÖ
2. bash (²»¾«Í¨Ò²ÒªÊì) LINUXÓë ......
²éѯ±íempÖÐËùÓÐÊý¾Ý
select emp_id,rownum from emp
µÚÒ»²½£¬²éѯ½á¹û,rownum´ý¶¨
emp_id rownum
1 ? 1
2 ? 2
3 ? 3
4&n ......