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

trunc()º¯ÊýµÄѧϰ (oracle)

trunc()º¯ÊýÓÐÁ½ÖÖÓ÷¨ 1£ººóÃæ¸úÈÕÆÚ  2£º ºóÃæ¸úÊý×Ö
A£º SELECT a.times,to_date(a.times,'yyyymmdd'),trunc(to_date(a.times,'yyyymmdd'),'month') from dmf_loan_limit a
ÏÔʾµÄ½á¹ûΪ£º
1 20080131     2008-1-31    2008-1-1
2 20080131     2008-1-31    2008-1-1
3 20080131     2008-1-31    2008-1-1
4 20080131     2008-1-31    2008-1-1
5 20080229     2008-2-29    2008-2-1
6 20080229     2008-2-29    2008-2-1
7 20080229     2008-2-29    2008-2-1
8 20080229     2008-2-29    2008-2-1
9 20080331     2008-3-31    2008-3-1
10 20080331    2008-3-31    2008-3-1
11 20080331    2008-3-31    2008-3-1
12 20080331    2008-3-31    2008-3-1
13 20080430    2008-4-30    2008-4-1
½âÊÍ£ºtrunc(to_date(a.times,'yyyymmdd'),'month')  ½«a.times ת»»³É yyyymmddµÄÈÕÆÚÐÎʽ£¬²¢ÇÒ·µ»Øa.timeËùÔÚÔµĵÚÒ»Ì졣ͨ¹ýÕâ¸ö¹«Ê½¾Í¿ÉÒÔÇó³öÕâÌìµ½ÕâÔµĵÚÒ»ÌìÏà²î¾ßÌåµÄÌìÊý¡£
B: 
SELECT a.times,to_date(a.times,'yyyymmdd'),trunc(to_date(a.times,'yyyymmdd'),'year') from dmf_loan_limit a
1 20080131      2008-1-31      2008-1-1
2 20080131      2008-1-31      2008-1-1
3 20080131      2008-1-31      2008-1-1
4 20080131      2008-1-31      2008-1-1
5 20080229     


Ïà¹ØÎĵµ£º

ORACLEÎﻯÊÓͼ Query RewriteµÄÒ»°ãÀí½âÖ®ËÄ


   ¿ÉÒÔ¿´µ½MVIEWÔÚQuery RewriteÖеÄÖØÒªÐÔ, ÒªÔÚʵ¼ÊÓ¦ÓÃÖÐʹÓÃ, ¾ÍµÃÖªµÀËüµÄºÜ¶à·½Ãæ, ÆäÖÐË¢ÐÂÊÇ×îÖ÷ÒªµÄ:
1, MVIEWÈÕÖ¾µÄ½¨Á¢
2, »ã×ÜÐ͵ÄMIVEWµÄË¢ÐÂ
3, JOINÀàÐ͵ÄMVIEWµÄË¢ÐÂ
4, ¸ü¸´ÔÓµÄMVIEWµÄË¢ÐÂ
5, ·ÖÇøÊ±µÄMVIEWµÄË¢ÐÂ
   ÔÚÕâ¶ùÎÒÃÇÖ÷ÒªÌÖÂÛµÄÊÇÈçºÎʵÏÖFastË¢ÐÂ, ·ñÔòûÓжàÉ ......

OracleÊý¾Ý¿â±í¿Õ¼ä²Ù×÷

// ½¨Á¢±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
create TABLESPACE EAS_D_sptcc0_STANDARD DATAFILE 'F:\oracledb\EAS_D_sptcc0_STANDARD.dbf' size 10000M EXTENT MANAGEMENT local;
// ɾ³ý±í¿Õ¼ä£¨Ö¸¶¨Îļþ·¾¶£©¡£
DROP TABLESPACE temp_data INCLUDING CONTENTS AND DATAFILES;
// ½¨Á¢ÁÙʱ±í¿Õ¼ä¡£
CREATE TEMPORARY TABLESPA ......

Oracleά»¤³£ÓÃSQLÓï¾ä

1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
¡¡¡¡select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
¡¡¡¡from dba_tablespaces t, dba_data_files d
¡¡¡¡where t.tablespace_name = d.tablespace_name
¡¡¡¡group by t.tablespace_name;
¡¡¡¡
¡¡¡¡2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
¡¡¡¡select tablespace_ ......

oracleÊý¾Ý×ÖµäС½á


ÏÂÃæ°´Àà±ðÁгöһЩORACLEÓû§³£ÓÃÊý¾Ý×ÖµäµÄ²éѯʹÓ÷½·¨¡£
   
    Ò»¡¢Óû§
    ²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
    SQL>select username,default_tablespace from user_users;
    ²é¿´µ±Ç°Óû§µÄ½ÇÉ«
    SQL ......

Oracle±Ê¼Ç ÎﻯÊÓͼ

http://www.wangchao.net.cn/bbsdetail_1776477.html
¡¡µÚ 13 Õ ÎﻯÊÓͼ
¡¡¡¡8.1.5ÆóÒµ°æ/¸öÈ˰濪ʼ֧³Ö
¡¡¡¡ÐèҪȨÏÞ£ºGRANT CREATE MATERIALIZED VIEW£¬»¹±ØÐëÖ±½Ó¸³ÓèGRANT QUERY REWRITE.ΪʵÏÖ²éÑ¯ÖØÐ´£¬±ØÐëʹÓÃCBO.
¡¡¡¡ 
¡¡¡¡ 
¡¡¡¡ 
¡¡¡¡ 
¡¡¡¡ 
¡¡¡¡ 
¡¡¡¡ 
¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ