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

OracleÐÐתÁÐʵÀý

ѪҺÃ÷ϸ±íÈçÏ£º
create table "blood"."OC_CarryOrderD"  (
     ID                   nvarchar2(20)                   not null,
    "ProductCode"        nvarchar2(10),
     "BloodGroup"         nvarchar2(10)
);
ÓбàºÅ£¬²úÆ·Àà±ðºÍѪÐÍÈý¸ö×Ö¶Î
Êý¾ÝÈçÏ£º
Òª¼ÆËãijһ²úÆ·µÄ²»Í¬ÑªÐ͵ĴüÊý
¾ÍÒª½«±íÐÐתÁУ¬×ö³ÉÈçÏÂЧ¹û£º
´úÂëÈçÏÂ
select productcode,
MAX(decode(rn, 1, codesum, NULL)) A,
MAX(decode(rn, 2, codesum, NULL)) AB,
MAX(decode(rn, 3, codesum, NULL)) B,
MAX(decode(rn, 4, codesum, NULL)) O
from
(
       select productcode,bloodgroup,codesum,row_number() over(PARTITION BY productcode ORDER BY bloodgroup, codesum) rn from (
       select productcode,bloodgroup, count(productcode) as codesum from oc_carryorderd2 group by productcode,bloodgroup order by bloodgroup)
)
group by productcode;
×¢Ò⣺ MAXºóÃæµÄÁÐÃû(A,AB,B,O)ҪעÒâ°´×Öĸ˳ÐòÅÅÁУ¬ÒòΪºóÃæµÄselectÓï¾äÊǰ´ÑªÐÍ×Ö¶ÎÉýÐòÅÅÁеÄ
¶ÔÿÖÖ²úÆ·µÄ´üÊý×ö¸ö»ã×Ü£¬ÈçÏÂͼ
¿ÉÒÔÔÚMAXºóÃæ¼ÓÈë²éѯ×Ö¶Î sum(codesum)


Ïà¹ØÎĵµ£º

oracle´¦Àíʱ¼äµÄ³£Óú¯Êý

36.ADD_MONTHS
¡¡¡¡Ôö¼Ó»ò¼õÈ¥Ô·Ý
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡200002
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),-2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡199910
¡¡¡¡37.LAST_DAY
¡¡¡¡·µ» ......

Oracle IO ²âÊÔ¹¤¾ßORION

Ò»Ö±ÏëѧϰÈçºÎµÃµ½Êý¾Ý¿âµÄIOÊý¾Ý£¬ORIONÊÇÒ»¸ö²»´íµÄ·ÂÕæ²âÊÔOracle IOµÄ¹¤¾ß¡£
ÏÂÃæÊÇÎҵIJâÊԵIJ½Ö裺
1 ´ÓoracleµÄÍøÕ¾ÉÏÏÂÔØORIONµÄÈí¼þ£¨11.1.0.7£©
2 ½âѹorion_linux_x86-64.gz
3 ½¨Á¢²ÎÊýÎļþ mytest.lun£¬ ÕâÀïµÄÁгöµÄÊÇ·ÖÇøÉ豸£¬ÎÒÔÚÉÏÃæ½¨Á¢ÁËasmÎļþϵͳ¡£ÒòΪÓÐÊý¾ÝÔÚÀïÃæ£¬ËùÒÔÎÒÓÃwrite=0Ö»²âÊ ......

Oracle RACѧϰ±Ê¼Ç

Oracle RACѧϰ±Ê¼Ç
1. Introduction:
Cluster - ¶ÔÓû§À´Ëµ¶ą̀·þÎñÆ÷ºÃÏñÊÇһ̨·þÎñÆ÷Ò»Ñù¡£
Oracle Clusterware - OracleÌṩµÄ¼¯Èº½â¾ö·½°¸
Oracle RAC ¶à¸öʵÀý¶ÔÓ¦Ò»¸öÊý¾Ý¿â£¨Îļþ£©
Oracle Cluster Architecture:  (Hardware)
Oracle RAC Á©¸ö×é¼þ£ºVoting DiskºÍOCR £¨Oracle Cluster Register£©
Voti ......

oracleÓësql server¶Ô±È·ÖÎö

±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊðÃû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºSadequl Hussain | Ô­ÎÄ£ºhttp://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
Ò» ......

WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â ת

WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£ÎÒÃÇ¿ªÊ¼°É£¡
¡¡¡¡Ê×ÏȽ«ORACLE 10gµÄ°²×°¹âÅÌ·ÅÈë¹âÇý£¬Èç¹û×Ô¶¯ÔËÐÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ