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

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ºóÓÐЧ£º£© ËùÒÔ²»»á´æÔÚÈ¡´íÖµµÄÎÊÌâ¡£


Ïà¹ØÎĵµ£º

linux redhat4+oracle10g

ÔÚÐéÄâ»úRed Hat Enterprise Linux 4 update 4Öа²×°oracle 10.2.0.1
1)²é¿´ÏµÍ³ÄÚ´æ
[root@linux4 ~]# grep MemTotal /proc/meminfo
2)²é¿´½»»»Çø´óС
[root@linux4 ~]# grep SwapTotal /proc/meminfo
3)
²é¿´/tmpĿ¼´óС
[root@linux4 ~]# df -m /tmp
4)²é¿´²Ù×÷ϵͳ°æ±¾
[root@linux4 ~]# cat /etc/issue
5)¼ ......

oracle apache phpÂÒÂëÎÊÌâ

°ì·¨Ò»
select * from V$NLS_PARAMETERS
  $conn = oci_connect('scott', 'donkey', 'demo', 'zhs16gbk');
 while ($dat = oci_fetch_row($cur)) {  
    print_r(iconv('gb2312', 'utf-8', $dat[0]));  //$nickname = mb_convert_encoding($dat[0], 'utf-8', 'gbk');&n ......

oracle ³£Ó÷ÖÎöº¯Êý

Oracle³£Ó÷ÖÎöº¯Êý
ROW_NUMBER
·µ»ØÓÐÐò×éÖÐÒ»ÐÐµÄÆ«ÒÆÁ¿£¬´Ó¶ø¿ÉÓÃÓÚ°´Ìض¨±ê×¼ÅÅÐòµÄÐкÅ
row_number() over(partition by ... order by ...)
RANK
¸ù¾ÝORDER BY×Ó¾äÖбí´ïʽµÄÖµ£¬´Ó²éѯ·µ»ØµÄÿһÐУ¬¼ÆËãËüÃÇÓëÆäËüÐеÄÏà¶ÔλÖá£×éÄÚµÄÊý¾Ý°´ORDER BY×Ó¾äÅÅÐò£¬È»ºó¸øÃ¿Ò»Ðи³Ò»¸öºÅ£¬´Ó¶øÐγÉÒ»¸öÐòÁУ¬¸ÃÐòÁ ......

OracleʵÀý¸ÅÄî½âÎö

OracleÊý¾Ý¿â·þÎñÆ÷ÓÉÁ½²¿·Ö×é³É£¬Ò»²¿·ÖÊÇORACLEÊý¾Ý¿â£¬Ò»²¿·ÖÊÇORACLEʵÀý¡£ORACLEÊý¾Ý¿â¾ÍÊÇ´æ´¢ÔÚ´ÅÅÌÉϵÄORACLEÊý¾ÝÎļþ¡¢ÈÕÖ¾ÎļþºÍ¿ØÖÆÎļþ¡£ÊµÀýÊÇÓÃÀ´¶ÔÊý¾Ý¿â½øÐвÙ×÷¡¢¹ÜÀíµÄ¡£ÊµÀýÓÉһϵÁнø³ÌºÍÄÚ´æ×é³É¡£
Æô¶¯Êý¾Ý¿âµÄʱºòÏÈÔÚÄÚ´æ·ÖÅäÒ»¿éºÜ´óµÄ´æ´¢¿Õ¼ä£¬È»ºóÆô¶¯ORACLEÊý¾Ý¿âÔËÐÐʱÐèÒªµÄһϵÁнø³Ì£¬¼´ ......

ORACLEÌåϵ½á¹¹ ÄÚ´æ½á¹¹

ORACLEÊý¾Ý¿âÆô¶¯Ê±·ÖÅäÒ»´ó¿é·Ç³£´óµÄÄÚ´æÇøÓò¡£ORACLEÔËÐйý³ÌÖÐËùÓеIJÙ×÷¶¼ÔÚÕâÀï½øÐС£
ORACLEÄÚ´æ=SGA+PGA¡£
SGA=Êý¾Ý¸ßËÙ»º³åÇø+ÈÕÖ¾»º³åÇø+¹²Ïí³Ø+´ó³Ø+Java³Ø¡£
Êý¾Ý¸ßËÙ»º³åÇø£ºÊý¾Ý¸ßËÙ»º³åÇøÊÇ×î½ü´ÓÊý¾ÝÎļþÖмìË÷³öÀ´µÄÊý¾Ý£¬»º´æÆðÀ´¹©ËùÓÐÓû§¹²Ïí¡£
ÈÕÖ¾»º³åÇø£º»º´æÓû§¶ÔÊý¾Ý¿âÖ´Ðеĸ÷Àà²Ù×÷µÄÖØ×ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ