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

ORACLE MODEL×Ó¾äѧϰ±Ê¼Ç

ORACLE 10GÖÐÐÂÔöµÄMODEL×Ó¾ä¿ÉÒÔÓÃÀ´½øÐÐÐÐ¼ä¼ÆËã¡£MODEL×Ó¾äÔÊÐíÏñ·ÃÎÊÊý×éÖÐÔªËØÄÇÑù·ÃÎʼǼÖеÄij¸öÁС£Õâ¾ÍÌṩÁËÖîÈçµç×Ó±í¸ñ¼ÆËãÖ®ÀàµÄ¼ÆËãÄÜÁ¦¡£
 
1¡¢MODEL×Ó¾äʾÀý
ÏÂÃæÕâ¸ö²éѯ»ñÈ¡2003ÄêÄÚÓÉÔ±¹¤#21Íê³ÉµÄ²úÆ·ÀàÐÍΪ#1ºÍ#2µÄÏúÁ¿£¬²¢¸ù¾Ý2003ÄêµÄÏúÊÛÊý¾ÝÔ¤²â³ö2004Äê1Ô¡¢2Ô¡¢3ÔµÄÏúÁ¿¡£
 
select prd_type_id,year,month,sales_amount
from all_sales
where prd_type_id between 1 and 2
and emp_id=21
model
partition by (prd_type_id)
dimension by (month,year)
measures (amount sales_amount)
(
Sales_amount[1,2004]=sales_amount[1,2003],
Sales_amount[2,2004]=sales_amount[2,2003] + sales_amount[3,2003],
Sales_amount[3,2004]=ROUND(sales_amount[3,2003]*1.25,2)
)
Order by prd_type_id,year,month;
 
ÏÖÔÚС·ÖÎöÒ»ÏÂÉÏÃæÕâ¸ö²éѯ£º
partition by (prd_type_id)Ö¸¶¨½á¹ûÊǸù¾Ýprd_type_id·ÖÇøµÄ¡£
dimension by (month,year)¶¨ÒåÊý×éµÄά¶ÈÊÇmonthºÍyear¡£Õâ¾ÍÒâζ×űØÐëÌṩÔ·ݺÍÄê·Ý²ÅÄÜ·ÃÎÊÊý×éÖеĵ¥Ôª¡£
measures (amount sales_amount)±íÃ÷Êý×éÖеÄÿ¸öµ¥Ôª°üº¬Ò»¸öÊýÁ¿£¬Í¬Ê±±íÃ÷Êý×éÃûΪsales_amount¡£
MEASURESÖ®ºóµÄÈýÐÐÃüÁî·Ö±ðÔ¤²â2004Äê1Ô¡¢2Ô¡¢3ÔµÄÏúÁ¿¡£
Order by prd_type_id,year,month½ö½öÊÇÉèÖÃÕû¸ö²éѯ·µ»Ø½á¹ûµÄ˳Ðò¡£
ÉÏÃæÕâ¸ö²éѯµÄÊä³ö½á¹ûÈçÏ£º
PRD_TYPE_ID       YEAR      MONTH SALES_AMOUNT
----------- ---------- ---------- ------------
          1       2003          1     10034.84
          1       2003          2     15144.65
          1       2003          3     20137.83
          1       2003   &


Ïà¹ØÎĵµ£º

OracleδÌṩÏàÓ¦Çý¶¯

  ±¾»úµçÄÔÉÏÓа²×°ORACLE10GµÄ¿Í»§¶Ë£¬ºóÀ´ÓÉÓÚÐèÒªÍæÁËÒ»ÏÂODAC£¬ºóÀ´ÓÖÐ¶ÔØµôÁË¡£½á¹û£¬Ê¹ÓÃC#½øÐÐÁ¬½ÓµÄʱºò±¨£º
        δÔÚ±¾µØ¼ÆËã»ú×¢²á“OraOLEDB.Oracle.1”Ìṩ³ÌÐò
  È»ºó£¬Ð½¨Ò»¸öUDL½øÐвâÊÔ£¬·¢ÏÖOracle   Provider & ......

ORACLE 10G´´½¨±í¿Õ¼äºÍ´´½¨Óû§

 1¡¢´´½¨±í¿Õ¼ä
CREATE TABLESPACE mytablespace DATAFILE   
  'F:\oracle\product\10.2.0\oradata\myoracle\MYTABLESPACE01.DBF' SIZE 500M AUTOEXTEND ON NEXT
100M MAXSIZE UNLIMITED  
LOGGING  
PERMANENT  
EXTENT MANAGEMENT LOCAL AUTOALLOCAT ......

ORACLE WITH AS Ó÷¨

¼ÇµÃÒÔǰÔÚÂÛ̳Àï¿´µ½inthirtiesÓõ½¹ýWITH ASÕâ¸ö×ÖÑÛ£¬µ±Ê±Ã»ÌرðÔÚÒâ¡£½ñÌìÔÚÒ»¸öÌû×ÓÀïÓÖ¿´µ½ÓÐÈËÓÃÕâ¸ö£¬ËùÒÔ¾ÍÈ¥ÍøÉÏËÑÁËËÑÏà¹ØÄÚÈÝ£¬×Ô¼ºÐ¡ÊÔÁËÒ»°Ñ£¬Ð´ÏÂÀ´£¬·½±ãÒÔºóÍüÁ˵Ļ°Ñ§Ï°¡£
===================================================================================
ÏȾٸöÀý×Ó°É£º
ÓÐÁ½ÕÅ±í£¬·Ö±ðΪA¡¢B ......

ORACLE to_char(),to_date()Ó÷¨

to_date() function
1.ÈÕÆÚ¸ñʽ²ÎÊý º¬Òå˵Ã÷ 
D Ò»ÖÜÖеÄÐÇÆÚ¼¸ 
DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û 
DD ÔÂÖеĵڼ¸Ìì 
DDD ÄêÖеĵڼ¸Ìì 
DY ÌìµÄ¼òдÃû 
IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ 
IYYY ISO±ê×¼µÄËÄλÄê·Ý 
YYYY ËÄλÄê·Ý 
YYY,YY,Y Äê·ÝµÄ×îºóÈýÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ