投入多少，收获多少；投入多深，领悟多深。太阳底下没有新鲜事，排列组合就是创新。每天多做一点点，就是进步的开始，每天进步一点点，就是成功的开始，每天创新一点点，就是领先的开始。
WHERE TO_NUMBER(SUBSTR()) 我的是可以的
上一篇 /
下一篇 2008-07-01 16:05:44
/ 个人分类：ORACLE
HUNTER@devjob>CREATETABLE T_PART (ID NUMBER, CREATE_DATE DATE)
2 PARTITION BY RANGE (CREATE_DATE)
3 (
4 PARTITION P2004 VALUES LESS THAN (TO_DATE('2005-1-1', 'YYYY-MM-DD')),
5 PARTITION P2005 VALUES LESS THAN (TO_DATE('2006-1-1', 'YYYY-MM-DD')),
6 PARTITION P2006 VALUES LESS THAN (TO_DATE('2007-1-1', 'YYYY-MM-DD')),
7 PARTITION P2007 VALUES LESS THAN (TO_DATE('2008-1-1', 'YYYY-MM-DD'))
8 );
Table created.
HUNTER@devjob>selecttable_name,partition_name from user_tab_partitions;
TABLE_NAME PARTITION_NAME
------------------------------ ------------------------------
T_PART P2004
T_PART P2005
T_PART P2006
T_PART P2007
HUNTER@devjob>SELECTTO_NUMBER(SUBSTR(PARTITION_NAME, 2)) FROM USER_TAB_PARTITIONS;
TO_NUMBER(SUBSTR(PARTITION_NAME,2))
-----------------------------------
2004
2005
2006
2007
HUNTER@devjob>SELECTTABLE_NAME, PARTITION_NAME FROM USER_TAB_PARTITIONS WHERE TO_NUMBER(SUBSTR(PARTITION_NAME, 2)) < 2006;
TABLE_NAME PARTITION_NAME
------------------------------ ------------------------------
T_PART P2005
T_PART P2004
HUNTER@devjob>SELECT* FROM
2 (
3 SELECT TABLE_NAME, PARTITION_NAME, TO_NUMBER(SUBSTR(PARTITION_NAME, 2)) PART
4 FROM USER_TAB_PARTITIONS
5 )
6 WHERE PART < 2006;
TABLE_NAME PARTITION_NAME PART
------------------------------ ------------------------------ ----------
T_PART P2005 2005
T_PART P2004 2004
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
