Oracle²åÈëÊý¾Ýʱ»ñÈ¡×ÔÔöID
×ÔÔö×ֶΣº
±íatable(id,a) idÐèÒª×ÔÔö Ê×ÏȽ¨Á¢Ò»¸öÐòÁУº
create sequence seq_atable minvalue 1 maxvalue 999999999999999999 start with 1 increment by 1 nocache
ÓжþÖÖ·½Ê½Ê¹ÓÃ×ÔÔö×ֶΣº
ʹÓÃÐòÁÐ+´¥·¢Æ÷ʵÏÖ×ÔÔö£¬²åÈëÓï¾ä²»ÐèÒª¹Ü×ÔÔö×Ö¶Î
È磺create or replace trigger trg_atable before insert on atable for each row begin select seq_atable.nextval into :new.id from dual; end;
²åÈëÊý¾Ý£ºinsert into atable(a) values('test');
×¢£ºÎÒ´´½¨ÁËsequence ºÍtrigger £º£¬Ö®ºóÔÚprocedureÖвåÈëÊý¾Ý£¬²åÈëµÄʱºòûÓйÜID×ֶΣ¬ÔÚÓ¦ÓÃÖУ¬Ê¹ÓÃÁËhibernate£¬ËäÈ»hibernateÔÚÔö¼Ó¼Ç¼µÄʱºòÒ²»á´¦ÀíID£¬µ«ÊÇÌí¼Ó¼Ç¼֮ºó£¬²éѯ¼Ç¼·¢ÏÖ£¬ID»¹ÊǸù¾ÝÐòÁкʹ¥·¢Æ÷µÄ¹æÔòÉèÖõÄ
½öʹÓÃÐòÁУ¬ÐèÒªÔÚ²åÈëÊý¾Ýʱ£¬×ÔÔö×ֶβåÈëÐòÁÐÏÂÒ»¸öÖµ
È磺insert into atable(id,a) values(seq_atable.nextval,'test');
Èý¡¢·µ»Ø¸Õ²åÈë¼Ç¼µÄ×ÔÔö×Ö¶ÎÖµ
ÈçÉÏÃæµÄÀý×Ó£¬ÎÒÃDzåÈëÒ»Ìõ¼Ç¼ºó£¬ÎÒÏëÂíÉÏ·µ»Ø¸Õ²åÈëµÄ¼Ç¼µÄIDºÅ£¬ÎÒ¸ÃÔõô´¦ÀíÄØ£¿
Ê×ÏÈÒª½â¾ö×ÔÔö×ֶεÄÎÊÌ⣬ÉÏÃæµÄ¶þÖÖ·½·¨ÄÄÖÖ¸üÊʺÏÕâÖÖÓ÷¨ÄØ£¿ ½¨ÒéʹÓõڶþÖÖ×ÔÔöÐòÁÐ,·ñÔò´¦ÀíÆðÕâ¸öÎÊÌâÀ´±È½ÏÂé·³¡£
ʹÓÃ×ÔÔö×ֶεĵڶþÖÖ·½·¨£¬ÔÚ²åÈëÒ»Ìõ¼Ç¼ºóÂíÉÏÖ´ÐÐÒ»ÏÂÏÂÃæµÄÓï¾ä¼´·µ»Øµ±Ç°²åÈëÊý¾ÝµÄID¡£
$query="select seq_atable.currval from dual";
seq_atable.currval µÄÖµÖ»ÓÐÔÚͬһ´Î»á»°ÖУ¬·¢Éúseq_atable.nextvalºóÓÐЧ£º£© ËùÒÔ²»»á´æÔÚÈ¡´íÖµµÄÎÊÌâ¡£
Ïà¹ØÎĵµ£º
Oracle RAC Workload Management:
service usage preferred instances available instances prority response time warning/critical
ERP &nb ......
Oracle³£Ó÷ÖÎöº¯Êý
ROW_NUMBER
·µ»ØÓÐÐò×éÖÐÒ»ÐÐµÄÆ«ÒÆÁ¿£¬´Ó¶ø¿ÉÓÃÓÚ°´Ìض¨±ê×¼ÅÅÐòµÄÐкÅ
row_number() over(partition by ... order by ...)
RANK
¸ù¾ÝORDER BY×Ó¾äÖбí´ïʽµÄÖµ£¬´Ó²éѯ·µ»ØµÄÿһÐУ¬¼ÆËãËüÃÇÓëÆäËüÐеÄÏà¶ÔλÖá£×éÄÚµÄÊý¾Ý°´ORDER BY×Ó¾äÅÅÐò£¬È»ºó¸øÃ¿Ò»Ðи³Ò»¸öºÅ£¬´Ó¶øÐγÉÒ»¸öÐòÁУ¬¸ÃÐòÁ ......
½ñÌì×ö¸ß¼¶¸´ÖÆÊµÑ飬ִÐе½Ìí¼Ómaster siteʱÓöµ½´ËÎÊÌ⣬ÉÏÍøËÑÁËËÑ£¬ÓÐÈçϼ¸ÖÖÒâ¼û£º
1.ÊÚȨ¹ý³Ì²»¶Ô——Çë×Ðϸ°´ÕÕÎĵµÉϵÄ˵Ã÷½øÐС£
2.°æ±¾ÎÊÌâ——¿É²é¿´v$optionÊÓͼÖÐÏà¹Ø²ÎÊýÊÇ·ñΪtrue¡£
3.°æ±¾ÎÊÌâ——ÓиöתÌùmetalinkµÄÎÄÕÂÉÏ˵ֻÓÐoracleÆóÒµ°æÖ§³Ö¸ß¼¶¸´ÖÆ¡£
¶¼Ã»Óн⾠......
ÔÚORACLEʵÀýÆô¶¯Ê±³ýÁË·ÖÅäÒ»¿éºÜ´óÇøÓòµÄÄÚ´æÍ⣬»¹»áÆô¶¯Ò»ÏµÁеĽø³Ì¡£OracleÖеĽø³ÌÓÐÄÄÐ©ÌØµã£¿
ORACLE½ø³Ì¿ÉÒÔ·ÖΪÓû§½ø³Ì¡¢·þÎñÆ÷½ø³Ì¡¢ºǫ́½ø³Ì¡£
Óû§½ø³Ì£ºÓû§Á¬½ÓÊý¾Ý¿âʱ»á´´½¨Ò»¸öÓû§½ø³Ì£¬¸Ã½ø³ÌÓÃÓںͷþÎñÆ÷½øÐлỰ£¬ÏòÊý¾Ý¿â·þÎñÆ÷·¢ÉúÇëÇ󣬽ÓÊÕÊý¾Ý¿âµÄÏìÓ¦¡£
·þÎñÆ÷½ø³Ì£ºÓÉORACLEÊý¾Ý¿â·þÎñÆ÷ ......
ÈÏʶ´æ´¢¹ý³ÌºÍº¯Êý
´æ´¢¹ý³ÌºÍº¯ÊýÒ²ÊÇÒ»ÖÖPL/SQL¿é£¬ÊÇ´æÈëÊý¾Ý¿âµÄPL/SQL¿é¡£µ«´æ´¢¹ý³ÌºÍº¯Êý²»Í¬ÓÚÒѾ½éÉܹýµÄPL/SQL³ÌÐò£¬ÎÒÃÇͨ³£°ÑPL/SQL³ÌÐò³ÆÎªÎÞÃû¿é£¬¶ø´æ´¢¹ý³ÌºÍº¯ÊýÊÇÒÔÃüÃûµÄ·½Ê½´æ´¢ÓÚÊý¾Ý¿âÖеġ£ºÍPL/SQL³ÌÐòÏà±È£¬´æ´¢¹ý³ÌÓкܶàÓŵ㣬¾ßÌå¹éÄÉÈçÏ£º
* ´æ´¢¹ý³ÌºÍº¯ÊýÒÔÃüÃûµÄÊý¾Ý¿â¶ÔÏóÐÎʽ´æ´¢ ......