OracleµÄ ¼òµ¥ÐÐתÁÐ
Ó¦¸ö±¨±íÒªÇó×ö¸ö
ʱ¼ä ˫ɫÇò£¬ ʤ¸º²Ê¡£¡£¡£¡£¡£
200905 ÏúÁ¿ ÏúÁ¿
200906 ÏúÁ¿ ÏúÁ¿
200907 ÏúÁ¿ ÏúÁ¿
200908 ÏúÁ¿ ÏúÁ¿
Ò»¸öSQL Óï¾äµÃµ½½á¹ûÊÇ£º
f_yearmonth, lot_name,money
200905 ˫ɫÇò 50
200905 ʤ¸º²Ê 100
200906 ˫ɫÇò 60
200906 ʤ¸º²Ê 70
Select f_yearmonth,
Max(decode(f_lotname,'˫ɫÇò',f_money,0)) As "˫ɫÇò",
Max(decode(f_lotname,'¸£²Ê3D',f_money,0)) as "¸£²Ê3D",
Max(decode(f_lotname,'ʤ¸º²Ê',f_money,0)) as "ʤ¸º²Ê",
Max(decode(f_lotname,'ʱʱ²Ê',f_money,0)) as "ʱʱ²Ê",
Max(decode(f_lotname,'ʱʱÀÖ',f_money,0)) as "ʱʱÀÖ",
from
t_tmp_test_A
Group By f_yearmonth
Order By f_yearmonth
¹Ø¼üÓï¾ä£º
Max(decode(f_lotname,'˫ɫÇò',f_money,0)) As "˫ɫÇò",
Group By f_yearmonth
ӦΪ °´Ê±¼äÖØ×éÖ»ÓÐÒ»Ìõ£¬²¢ÇÒÖ»ÓÐÒ»ÌõÊý¾Ý£º 200905 ˫ɫÇò 50
ÄÇô ÓÃMAXȡһÌõÊý¾Ý ¾ÍÊÇ50
decode Òâ˼˵ Èç¹ûÊǑ˫ɫÇò’ È¡¶ÔÓ¦µÄf_money ²¢ÇÒ·ÅÔÚ ÃüÃûΪ "˫ɫÇò"µÄ ÁÐÉÏ¡£
ºÜÏÔÈ» ÕâÁÐÊǹ̶¨£¡
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
7¡¢¶ÔÏóÀàÐͼ̳Ð
¶ÔÏóÀàÐÍʵÏÖÔÊÐíÎÒÃÇ´´½¨Ò»¸ö»ùÀàÐÍ£¬»ò½Ð¸¸ÀàÐÍ£¬ÕâÖÖÀàÐ͵ÄÊôÐÔ»ò·½·¨¿ÉÒÔ±»ÁíÒ»¸ö¶ÔÏóÀàÐͼ̳С£È»ºó¿ÉÒÔ´´½¨Ò»¸ö×ÓÀàÐÍ£¬»ò½Ðº¢×ÓÀàÐÍ£¬Ö±½ÓʹÓü̳йýÀ´µÄÊôÐÔ»ò·½·¨£¬»òÕßÓÃ×Ô¼ºµÄÊôÐԺͷ½·¨ÖØÐ´¸¸ÀàÐ͵ÄÊôÐÔ»ò·½·¨¡£
INSTANTIABLE¹Ø¼ü×Ö±íʾÎÒÃÇ¿ÉÒÔ´Ó¸ÃÀàÐÍÖÐʵÀý»¯»òÕß´´½¨¶ÔÏ ......
Oracle¹«Ë¾Ðû³ÆÔÚLinuxϰ²×°Oracle9iÊý¾Ý¿âÖÁÉÙÒªÓÐ512MBµÄÄÚ´æºÍÖÁÉÙ1GB»òÕßÁ½±¶
ÄÚ´æ´óСµÄ½»»»¿Õ¼ä£¬¶ÔÓÚϵͳÄÚ´æ´óÓÚ2GBµÄ·þÎñÆ÷£¬½»»»¿Õ¼ä¿ÉÒÔ½éÓÚ2GB—4GBÖ®¼ä¡£
Èç¹ûÊÇΪÁËÔÚһ̨½öÓÐ256MÄÚ´æµÄÆÕͨPC»úÉÏÊÔÓÃOracle9i£¬ÔÚ·ÖÅäÁË1GB×óÓҵĽ»»» ......
ÿ¸öOracleÓû§¶¼ÓÐÒ»¸öÃû×ֺͿÚÁî,²¢ÓµÓÐһЩÓÉÆä´´½¨µÄ±í¡¢ÊÓͼºÍÆäËû×ÊÔ´¡£Oracle½ÇÉ«£¨role£©¾ÍÊÇÒ»×éȨÏÞ£¨privilege£©(»òÕßÊÇÿ¸öÓû§¸ù¾ÝÆä״̬ºÍÌõ¼þËùÐèµÄ·ÃÎÊÀàÐÍ)¡£Óû§¿ÉÒÔ¸ø½ÇÉ«ÊÚÓè»ò¸³ÓèÖ¸¶¨µÄȨÏÞ£¬È»ºó½«½ÇÉ«¸³¸øÏàÓ¦µÄÓû§¡£Ò»¸öÓû§Ò²¿ÉÒÔÖ±½Ó¸øÆäËûÓû§ÊÚȨ¡£
Êý¾Ý¿âϵͳȨÏÞ£¨Database System Privil ......
ORACLEÏà¹ØÓï·¨ ÊÕ²Ø
Ò»¡¢OracleÈëÃÅ
ÀíÂÛ֪ʶ£º
OracleµÄÎïÀí×é¼þÓÐÈý¸ö£º
(1)Êý¾ÝÎļþ Êý¾ÝÎļþÊÇÓÃÓÚ´æ´¢Êý¾Ý¿âÊý¾ÝµÄÎļþ£¬Èç±í¡¢Ë÷ÒýÊý¾Ý¡£Ã¿¸öOracleÊý¾Ý¿âÓÐÒ»¸ö»ò¶à¸öÎïÀíÊý¾ÝÎļþ£¬
&nbs ......