okkeqin的专栏

SELECT column_id,parent_id FROM t_column  START WITH column_id=50501    CONNECT BY PRIOR   parent_id  = column_id

1、分区表(11g interval 自动分区)： Create table t_cdr_log (    seqno number,    userid varchar2(20),    ctime  date default sysdate ) partition by range(ctime)   INTERVAL (NUMTODSINTERVAL(1,'day'))(