Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ¹éµµÓë·Ç¹éµµÄ£Ê½

ÔÚ
Oracle
Êý
¾Ý¿â
ÖУ¬
Ö÷ÒªÓÐÁ½ÖÖ
ÈÕÖ¾
²Ù×÷ģʽ£¬·Ö±ðΪ·Ç¹é
µµÄ£Ê½Óë¹éµµÄ£Ê½¡£Ä¬ÈÏÇé¿öÏ£¬Êý¾Ý¿â
²É
ÓõÄÊǷǹ鵵ģʽ
¡£×÷Ϊһ¸öºÏ¸ñµÄÊý¾Ý¿â¹Ü
Àí
Ô±£¬Ó¦µ±ÉîÈëÁ˽âÕâÁ½ÖÖÈÕÖ¾²Ù×÷ģʽµÄÌØµã£¬²¢ÇÒÔÚÊý¾Ý¿â½¨Á¢Ê±£¬Ñ¡
ÔñºÏÊʵIJÙ×÷ģʽ¡£
¡¡¡¡±ÊÕß
½ñÌì¾Í̸̸×Ô¼º¶ÔÕâÁ½ÖÖ²Ù×÷ģʽµÄÀí½â£¬²¢ÇÒ¸ø³ö ......

oracle´´½¨±í¿Õ¼ä.´´½¨Óû§.´´½¨±í

ÔÚSQL*PlusÖУº£¨1£©ÈçºÎÌí¼Óɾ³ýÊý¾Ý¿â£¿£¨2£©Êý¾Ý¿â¾ÍÊDZíÂ𣿣¿£¨3£©ÈçºÎ´´½¨±í¿Õ¼ä£¿£¨4£©ÈçºÎ´´½¨Óû§£¿£¨5£©ÊDz»ÊÇÒ»¸ö±í¿Õ¼äÖ»ÄÜ´´½¨Ò»¸öÓû§£¿£¨6£©ÔõÑù´Ó¿Í»§¶Ë·ÃÎÊÊý¾Ý¿â·þÎñÆ÷µÄÅäÖã¿
¡¡¡¡
¡¡¡¡»Ø´ð£º
¡¡¡¡1¡¢ºÎÌí¼Óɾ³ýÊý¾Ý¿â£¿Ã»ÕâÖÖ¸ÅÄ²»¶®¡£
¡¡¡¡2¡¢Êý¾Ý¿â=ËùÓеÄoracleµÄÊý¾ÝÎļþ+¿ØÖÆÎļþ+ÈÕÖ¾Îļ ......

oracle³£Óú¯Êý,sybase³£Óú¯Êý

oracle³£Óú¯Êý-----------------------------------------------
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- - ......

Windos Ï Oracle Êý¾Ý¿â¹ÜÀí


1. ´´½¨ÐµÄÊý¾Ý¿âʵÀý£º
D:\oracle\product\10.2.0\admin\adidb\scripts>dbca
2.Æô¶¯ºÍ¹Ø±ÕʵÀý
D:\oracle\product\10.2.0\admin\adidb\scripts>net start oracleserviceorcl
D:\oracle\product\10.2.0\admin\adidb\scripts>net stop oracleserviceorcl
3.Á¬½ÓÊý¾Ý¿âʵÀý
1> ÉèÖÃoracle_sid (set o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ